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.

Also, if F2 is before 01/01/08, I need to have the formula calculate
the days as if F2 = 01/01/08


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()

and also calculating F2 as starting 01/01/08 if F2 is before 01/01/08


Is this a possibility?


Any help is greatly appreciated.