5 days from now

J

johnfli

I need help in writing a formula (or a macro) that when a date is entered in
one column, in another column, it will calculate what the date in 5 days
will be (counting the date that was entered in) Saturday and Sunday are
not to be counted as part of the 5 days.

thanks
 
M

Myrna Larson

Look at the WORKDAY function. You need to install the Analysis Tool Pak to use
it. All is explained in Help.
 
M

millsy

johnfli said:
I need help in writing a formula (or a macro) that when a date i
entered in
one column, in another column, it will calculate what the date in
days
will be (counting the date that was entered in) Saturday and Sunda
are
not to be counted as part of the 5 days.

thanks
Click to expand...

Enter your date in cell A1 then in B1 enter:

=if(day(a1)=1,a1+4,a1+6)

You need to format B1 as a date too
 
Top