I have seen many threads on this subject, but no full solutions to what I am looking to accomplish.
The retail store I work in has a monthly cash-tracking sheet we need to fill. I am currently creating a template that could be used month-by-month. I've used formulas such as =DATE(YEAR(TODAY()),MONTH(TODAY()),1) liberally on this. I want to make the person entering data's job as easy as possible, not having to manually enter date ranges and such left and right. There are several different rows and columns using similar formulas to auto-fill dates.
What I would like to do is have these templates function in a way so that they could be opened (for example, in Feb), then all of the "feb" or (02) sections would be locked in once the sheet is worked on. The main issue I'm running into is that if the sheet is opened and worked on in any instance other than during February, all of the dates will be out of wack.
tl;dr: looking for a quick way to essentially "lock in" dates for a given month the sheet is worked on (we have a wb for each month) after the sheet is worked on.
Bookmarks