PDA

View Full Version : Solved: Add NETWORKDAYS to a date



Philcjr
12-15-2006, 09:11 AM
How can I add 20 "NETWORKDAYS" to a given date?

I have a beginng date
I have number of working days (less weekends)
I want to figure out the "date" after the working days are added to the beginning date

I would like to do this with a formula not VBA.

Thanks,
Phil

Bob Phillips
12-15-2006, 09:55 AM
=WORKDAY(A1,20)

Zack Barresse
12-15-2006, 10:24 AM
LOL! You gotta love the simplicity. :)

Hope things are well for ya Phil. Been meaning to email you. Have a good holidays!!! :yes

Philcjr
12-15-2006, 03:12 PM
Thanks XLD... as usual you save the day :)

Zack, I'll e-mail you soon... now, I am off on vacation.

Phil