ExcelBanter - Excel Formulas

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Excel Formulas (https://www.excelbanter.com/new-users-excel/213713-excel-formulas.html)

LH4045

Excel Formulas

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.

Gary''s Student

Excel Formulas

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.

Rick Rothstein

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.

All times are GMT +1. The time now is 02:36 AM.