I am trying to make an attendance and time sheet for my team at work. However, we only work on MWF. How can I autofill dates in a row but skip weekends?
Have been looking at the WORKDAY function.
I successfully have GSheets repeat every other day, but I need to skip dates that fall on Sunday.
Current: (01/07, 01/09, 01/11, 01/13, 01/15)
Expected: (01/07, 01/09, 01/11, 01/15)
For the sake of discussion, we'll assume the dates are in column A.
Enter the first three dates manually.
Then for the fourth date use =DATEVALUE(A1) +7.
Then copy the fourth cell down as far as you need.
Credit: Bob Umlas, Excel MVP
With a Monday date in A1, in A2 and dragged across to suit:
=A1+if(weekday(A1)<>6,2,4)
should create a series of successive Monday, Wednesday and Friday dates.