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.
|