Help with Excel Formula? Setting date/time?

Question

I have an excel spreadsheet (schedule) that I need to create at the end of each day. For example, Wednedsday's schedule is printed Tuesday night. I know I can set the date by using =Today()+1 However on Friday, it puts in Saturdays date.....How can I set it to skip Saturday and Sunday automatically each week?

Answer 1

by using weekday() and an IF() statement. With day() function you know which day of the wekk today() is and with the if statement you can decide whether to add 1 or 3
if today is a Friday then add 3 (for monday)
if not add 1

by default the first day of the week is sunday, so weekday returns 1 for sundays, 2 for mondays, ... , 7 for saturdays

the formula could be :
=IF(WEEKDAY(TODAY())=6,TODAY() + 3 ,TODAY() +1 )

Answer 2

You can use weekday() function to tell you which it is. So weekday(today()) will return a value between 1 and 7. You then use IF(test condition, value if true, value if false) to return a diffrent value based on which day it is.

So your formulla will look like if(weekday(today()) = 7, today() + 3, today() + 1).

Answer 3

You need to add a couple of IF's and the weekday formula, here you go:
=IF(WEEKDAY(TODAY()+1,2)=5,TODAY()+3,IF(WEEKDAY(TODAY()+1,2)=6,TODAY()+2,TODAY()+1))

Which means: IF today+1 is friday then calculate today+3 (sat, sun, mon), else IF today+1 is saturday then calculate today+2 (sun, mon)

Answer 4

i have executed similar issues. one component that you would possibly want to do is determined up a worksheet call it changelog and insert correct right here code into the web page that you want to music. it is going to coach you the row and column of each and every cellular that become replaced and a timestamp for at the same time as it become replaced. for sure, you may continuously placed if..then statements in to diminish the cells you're monitoring or placed more advantageous columns into the changelog to music different issues (person call, cellular values, and so on) inner most Sub Worksheet_SelectionChange(ByVal purpose As variety) endrow = Sheets("changelog").variety("A65536").end(... + a million Sheets("changelog").Cells(endrow, a million) = purpose.Cells.Row Sheets("changelog").Cells(endrow, 2) = purpose.Cells.Column Sheets("changelog").Cells(endrow, 3) = Now() end Sub