Subtract working days

T

teeb

I'm tring to calculate todays date and subtract a number of working days
and have the answer in date format.

A1 = 02 November 05
B1 = 5
C1 = Would result in 27 October 05




Any help would be appreciated
 
P

Paul Sheppard

teeb said:
I'm tring to calculate todays date and subtract a number of working day
and have the answer in date format.

A1 = 02 November 05
B1 = 5
C1 = Would result in 27 October 05




Any help would be appreciated
Click to expand...

Hi teeb

In A1 you could use =TODAY()

In C1 put ---> =WORKDAY(A1,-A2+1
 
Top