Back tracking dates
Hi Mike,
Thank you for your help. I used your formula per your first response and
it works fine:
In "B2" I have: =WORKDAY(C2,-A2,Sheet2!A2:B1000)
and the result is 8/29/07:
Sheet1:
Column A Column B Column C
Duration Start date End date
3 8/29/07 9/5/07
Sheet2 (vacation / holidays):
Column A Column B Column C Column D
Holidays Mr. A Mr. B Mr. C
9/03/07 9/04/07 9/07/07 8/31/07
FYI:
However, when I used your new formula
(=C2-(DAY(WORKDAY(C2,A2,Sheet2!A2:B1000)))), the result is 8/26/07 instead.
Thanks for your help.
Regards,
Bau
"Mike H" wrote:
Apologies i misread your post you want the start date, Try this
=A1-(DAY(WORKDAY(A1,A2,B1:B8)))
End date in a1
days work in a2
Mike
"bau" wrote:
Hi all,
Say that I have a project which must be completed by Sept 05 2007 and it
will take 3 days to complete it. Since Sept 1 and 2 are weekend and Sept 03
is a holiday, also, Mr. A, who will perform this task will take a vacation on
Sept 04. What formular I have to use?
Sheet1:
Column A Column B Column C
Duration Start date End date
3 ??? 9/05/07
Sheet2 (vacation / holidays):
Column A Column B Column C Column D
Holidays Mr. A Mr. B Mr. C
9/03/07 9/04/07 9/07/07 8/31/07
Thanks,
Bau
|