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.

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.

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.

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

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

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")

"Gary Keramidas" wrote:

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.

On Sat, 7 Jun 2008 22:20:19 -0700, "DonV" wrote:

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