Subtract working days

[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

 

[Paul Sheppard]

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

Hi teeb

In A1 you could use =TODAY()

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