On Tue, 16 Jul 2013 23:01:44 +0100, lostgrave2001 wrote:


Hello

Im struggling and cant locate a fix please help.

i have a date Exp: 20/01/13 in cella A2 and i want cell B2 to show me
the previous working day. Coluld someone please help me?

Thanks in Advance.

Chris

P.s i am using excel 2003

b2: =workday(a2,-1)

If you get a #NAME error, examine HELP for the WORKDAY function for instructions on adding the Analysis ToolPak