Formula for a 4 day work week
You could use the Workday function.
In A1, enter the first Friday of 2007 (or whatever year you need)
1/5/07
In A2, enter =A1+7, then copy down as far as needed (my example is in A1:A52).
Then with your start date in B1 and number of days in B2, enter
=WORKDAY(B1,B2,A1:A52)
"tamarade" wrote:
I am trying to create a formula that will result in a date. I have a start
date, a number of work days, however my dilemna is we only work 4 days. So
the formula would have to compute a completion date but exclude Fri, sat, &
sunday, any suggestions?
|