Backtrack work days

B

Brian

I have a sheet that has a list of days in column A. In
column B, I would like to be able to list the date of 6
prior working days. For example, in cell A1 I have
11/19/2003 and in cell B1, I would like it to show
11/11/2003. What is the correct formula to use?

TIA
 
J

Jim

There is undoubtedly a more elegant solution, but this will return the
serial dates:
=WORKDAY(A1,-1)&", "&WORKDAY(A1,-2)&", "&WORKDAY(A1,-3)&",
"&WORKDAY(A1,-4)&", "&WORKDAY(A1,-5)&", "&WORKDAY(A1,-6)
 
M

Myrna Larson

=WORKDAY(A1,-6)

You can supply a list of holidays as the 3rd argument. See Help for more information. This
function is in the Analysis Tool Pack. Help will tell you how to install that if you haven't
done so.
 
Top