Help with formula

  • Thread starter Thread starter DonV
  • Start date Start date
D

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.
 
what's wrong with =c3+30?
that's 30 days from the date in c3.

unless you have some other criteria.
 
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.
 
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")
 
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.
Click to expand...

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
 
Back
Top