date format
 

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?

date format
 

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?



"Anna" wrote:

I got it. Cheers
:D
=A1+CHOOSE(WEEKDAY(A1),1,0,0,0,0,0,2)

"Anna" wrote:

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

"Anna" wrote:

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?

date format
 

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

"Anna" wrote:

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?

date format
 

On Sun, 26 Mar 2006 14:53:42 -0800, Anna
wrote:

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?

=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