View Single Post
  #3   Report Post  
FSt1
 
Posts: n/a
Default

hi,
assuming your given date is in cell A1, try this.....

=WORKDAY(A1,30)

if you want to use diffenent numbers of days, put the number of days in cell
B1

=WORKDAY(A1,B1)

IF you want to go backwards into the past, enter negative days


adjust the formula to fit your data.

Regards
FSt1
"VDan" wrote:

I need a formula to calculate the date 30 business days from a given date.
Any help appreciated.