G Guest Jan 7, 2004 #1 Is there a way to autofill dates into a spreadsheet and only use workdays and not Saturdays and Sundays?
Is there a way to autofill dates into a spreadsheet and only use workdays and not Saturdays and Sundays?
P Peo Sjoblom Jan 7, 2004 #3 Depending on version yes, put the first date in a cell, right click the cell and copy it down, when you release the mouse button you can select weekdays..
Depending on version yes, put the first date in a cell, right click the cell and copy it down, when you release the mouse button you can select weekdays..
B Bob Phillips Jan 7, 2004 #4 You could try this. Put a non weekend-date in A1 Put this formula in A2 =IF(WEEKDAY(A1)=6,A1+3,A1+1) Copy it down -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) K McGee said: Is there a way to autofill dates into a spreadsheet and only use workdays Click to expand... and not Saturdays and Sundays?
You could try this. Put a non weekend-date in A1 Put this formula in A2 =IF(WEEKDAY(A1)=6,A1+3,A1+1) Copy it down -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) K McGee said: Is there a way to autofill dates into a spreadsheet and only use workdays Click to expand... and not Saturdays and Sundays?
