Hi, I have followed some advice to allow a list of dates excluding sundays. However i have encountered a problem.
In A1 I put the date: 23/04/12.
Then in A2 i put '=A1 +1 +(WEEKDAY(A1) =7)' as directed.
I then dragged the litte black cross down and it populated the the fields in that column.
That produced this:
41023
41024
41025
41026
41027
41029
41030
41031
41032
I notice that 41028 is missing, which would be the sunday date so something about the formulae is right, however. as you can see there is no date formatting, am i doing something wrong?
Thanks for your help.
Bookmarks