Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy back macro/roll back | Excel Worksheet Functions | |||
pulling back dates that meet certain criteria | Excel Worksheet Functions | |||
Need formula to calculate days between dates or back date | Excel Discussion (Misc queries) | |||
How to insert tracking numbers into my webpage for RMA tracking | Excel Discussion (Misc queries) | |||
tracking changes | Excel Discussion (Misc queries) |