Back tracking dates
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/04/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 |
Back tracking dates
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/04/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 |
All times are GMT +1. The time now is 10:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com