Thread
:
No Sat & Sundays
View Single Post
#
2
Posted to microsoft.public.excel.misc
Pete_UK
Posts: n/a
No Sat & Sundays
Enter your first date in A1 - ensure this is not a Saturday or Sunday.
In B1 enter this formula:
=IF(WEEKDAY(A1,2)=5,A1+3,A1+1)
Format this as a date, then copy across your columns.
Hope this helps.
Pete
Reply With Quote