Excel Formulas

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.
 
G

Gary''s Student

With your date or formula in A1:
=A1+(WEEKDAY(A1)=7)*2+(WEEKDAY(A1)=1) will change Saturday or Snday to the
following Monday.
 
R

Rick Rothstein

Same length, but saves a multiplication operation...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Easter - What U Up To? 17
conditional format of adjacent cell with different range and crite 1
WEEKDAY 7
Shift Schedule Formula 1
if date has Saturday or Sunday in it need to add 2 or 1 to date 2
Creating a rotating schedule 5
Need Programming Help 5
average hourly output for date, result shown by day 5

Top