Excel Formulas

  • Thread starter Thread starter LH4045
  • Start date Start date
L

LH4045

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.
 
With your date or formula in A1:
=A1+(WEEKDAY(A1)=7)*2+(WEEKDAY(A1)=1) will change Saturday or Snday to the
following Monday.
 
Same length, but saves a multiplication operation...

=A1+(WEEKDAY(A1,2)>5)+(WEEKDAY(A1)=7)
 
Back
Top