1
I am working on a monthly spreadsheet of our daily takings.
I need one line for a sunday, monday and tuesday but two lines for wednesday, thursday, friday and saturday. I can't seem to hit the magic formula to copy this down the column.
Wed 1/Oct/2014
Wed 1/Oct/2014
Thur 2/Oct/2014
Thur 2/Oct/2014
Fri 3/Oct/2014
Fri 3/Oct/2014
Sat 4/Oct/2014
Sat 4/Oct/2014
Sun 5/Oct/2014
Mon 6/Oct/2014
Tue 7/Oct/2014
I am sure there is a simple answer but I am stumped.
Its for a monthly spreadsheet of cash takings for our business. It's quiet on sun/mon/tues so there is only 1 cash register opened. The other days there are two cash registers opened so need two lines for these days. Sorry I don't understand algorithms – Vic – 2014-09-25T13:17:53.327
You need a line for the 10th of each month, except when it falls on Wed - Sat, in which case you need 2 lines? ah nevermind, this is dd/mm/yy - sorry. – Raystafarian – 2014-09-25T13:17:57.107
Oops - confusion may arise in my original post it's meant to be - 1 Oct 2014, 2 Oct 2014, etc In Australia dd/mm/yy. – Vic – 2014-09-25T13:21:02.497