Help with formula

[DonV]

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.

 

[Gary Keramidas]

what's wrong with =c3+30?
that's 30 days from the date in c3.

unless you have some other criteria.

 

[DonV]

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.

 

[DonV]

Sorry I just realized what you said. I was thinking I needed the formula.

 

[Joel]

You sure you didn't type the # in the cell. I have the US version, there are
some differences in the international version that I'm not aware of.

Try putting this formula in the workbook and see if you get three zeroes

=TEXT(0,"#000")

 

[Ron Rosenfeld]

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.

If you want a straight 30 days after your original date, then:

=C3+30

If you want to count 30 days, but then go to the next business day (e.g. if
c3+30 falls on a Sat, Sun or holiday) then use:

=WORKDAY(C3+29,1,holidays)

Where holidays is a reference to a list of holidays. It is optional so you
don't need to include it.
--ron