I'm having trouble getting a handle on this for some reason.
I have a worksheet that keeps a year to date and month to date total of overages or underages (end of day cash reconciliation). I need to have a formula that clears the month or year to date total cell at the appropriate time and I want to do this independant of the year as I generate a new sheet every day and enter yesterday's numbers.
I think I have the year figured out by picking the month and day and comparing but the only thing I have come up with for the month is comparing to a list of 13 dates (leap year).
Is there another way to do this that's simpler?
A new worksheet is generated every day for yesterday. The year to date and month to date are carried foreward and moved into a cell that shows the cumulative total for the prior day. This is the cell that needs to reset to empty (or zero) if yesterday was an end of the month day.
Bookmarks