date format

A

Anna

If I input a date in a1 (i.e.25mar06 or 26mar06), a2 will shows me next
working date - (27Mar06).
I know that it should be something like:
=if((a1=sunday,a1+1,a1)if(a1=sat.,a1+2,a1))
Anyone can help me?
 
T

Toppers

Anna,
Your change will show same date in A2 as A1 if A1 contains
workdays Monday to Friday. If "Today" is Friday i.e.in A1, then if
Saturday/Sunday are NOT weekdays, then you need to add 3 to Friday to get
Monday i.e. NEXT work day.

Hence 24 March FRIDAY will give 27th March MONDAY as next work day. How do
define workday?
 
A

Anna

For Toppers's solution,
if a1 = 24mar06 friday, next work day shows 27mar06 not 24mar06.
 
R

Ron Rosenfeld

If I input a date in a1 (i.e.25mar06 or 26mar06), a2 will shows me next
working date - (27Mar06).
I know that it should be something like:
=if((a1=sunday,a1+1,a1)if(a1=sat.,a1+2,a1))
Anyone can help me?
Click to expand...

=WORKDAY(A1,1)

If the WORKDAY function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.

--ron
 
Top