Hi there,
Not too sure how to explain this but I'll try.
Basically, I want to enter the date of the first day of a month into one cell.
Then the cells below it add the additional day (currently I have the formula "=weekday(a1, 1)" which is fine. However, everytime the month changes, the days change of course.
Is there a formula I can write where the days always remain in the same row, just the date of each month changes (also removing the weekend).
i.e
.................A.................B..............C.........
1 - Mon -.............. - ............. - 01/03/15
2 - Tue - 01/01/15 - ............... - 02/03/15
3 - Wed - 02/01/15 - .............. - 03/03/15
4 - Thu - 03/01/15 - 01/02/15 -
5 - Fri - 04/01/15 - 02/02/15 -
6 - Mon - 07/01/15 - 05/02/15
7 - Tue - 08/01/15
8 - Wed - 09/01/15
9 - Thu - 10/01/15
Obviously the above dates are not correct, it's just for the example.
If anyone could tell me the formula to use for this it would greatly appreciated!
Thanks
Bookmarks