Thread: date format
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld
 
Posts: n/a
Default 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