Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complicated working days calculation
I have a start date in F2 and an end date in G2. I am currently using
this formula for the number of working days, which works fine: =SUM(INT((WEEKDAY(F2-{2,3,4,5,6})+G2-F2)/7)) What I need to do though is have the formula count the number of working days from F2 up until today(), but only IF G2 is greater than today, and still count the number of working days from F2:G2 if G2 is less than today. Additionally, I need a formula to put in another column that will also count the number of working days from today() through G2, but only if G2 is greater than today() Is this a possibility? Any help is greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complicated working days calculation
Please see my other post with the same subject, I missed something in
this one. On Apr 29, 11:11*pm, Chris wrote: I have a start date in F2 and an end date in G2. I am currently using this formula for the number of working days, which works fine: =SUM(INT((WEEKDAY(F2-{2,3,4,5,6})+G2-F2)/7)) What I need to do though is have the formula count the number of working days from F2 up until today(), but only IF G2 is greater than today, and still count the number of working days from F2:G2 if G2 is less than today. Additionally, I need a formula to put in another column that will also count the number of working days from today() through G2, but only if G2 is greater than today() Is this a possibility? Any help is greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation of working days between two dates | Excel Worksheet Functions | |||
How to calculation no. of days (only working days) between two dat | Excel Discussion (Misc queries) | |||
Help with complicated calculation | Excel Worksheet Functions | |||
Working days and hours calculation - request assistance please! | Excel Worksheet Functions | |||
Dates calculation using working days | Excel Discussion (Misc queries) |