Excel Formulas
Same length, but saves a multiplication operation...
=A1+(WEEKDAY(A1,2)5)+(WEEKDAY(A1)=7)
--
Rick (MVP - Excel)
"Gary''s Student" wrote in message
...
With your date or formula in A1:
=A1+(WEEKDAY(A1)=7)*2+(WEEKDAY(A1)=1) will change Saturday or Snday to the
following Monday.
--
Gary''s Student - gsnu200820
"LH4045" wrote:
I have a sheet that tracks time alotted for work schedule over several
Months.
I need to force any formulas that return a Saturday or Sunday, to Monday.
|