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?