G'Day All,
Please refer to the attached spreadsheet as it should hopefully help in my rambled explanation of what i'm trying to do below.
I have a series of dates (not always beginning on a monday) to which I wish to calculate how many Sundays are being captured within that series. I don't always want to be calculating Sundays for every scenario so I'd like to be able to change this rostered day off and the entire function searches for that day, as opposed to a Sunday.
Each workbook (not worksheet) will only have 1 rostered day off, so if 1 workbook has the variable set to Sunday that will be perfect.
Any help in achieving this would be greatly appreciated!
Regards,
Xtopher
Bookmarks