Well I tried that but the date it returns is not thirty days from the given
date.

This is what I tried, =WORKDAY(C3,30)-WEEKDAY(WORKDAY(C3,30))

The given date is 5/25/08 the date returned is 6/28/08, I can't figure out
why. I believe it should be 6/24/08.

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
what's wrong with =c3+30?
that's 30 days from the date in c3.

unless you have some other criteria.

--


Gary


"DonV" wrote in message
...
I have a formula I use to calculate a date that is 21 days after a given
date.

=WORKDAY(C3,21)+7-WEEKDAY(WORKDAY(C3,21)-6)

This would return a date 21 days from a given date plus the Friday after
21 days. (not sure this made sense)

Anyway, I need to modify the formula to return a date that is based on
Net 30 from a given date.