Complicated working days calculation

C

Chris

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complicated working days function 7
Finding location (or start cell) of highest consecutive values 3
More date/counting functions 2
Avoiding redundant calculations 7
Todaysdateminus1and2 3
Conditional Formatting 4th Condition 3
Would like to input 3 letters into a cell, each having a different numerical value 5
Another Formula 3

Top