How to change a cell “Date” in Excel?Locked
I have a Excel spreadsheet to do a daily cash receipt report. Each month there is a different “reporting period”, i.e. Jan 2002, Feb 2002. Currently I manually change this cell at the beginning of each month to reflect the current month. How would Iformat this cell to automatically change to the current month?