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
|