Forum Discussion
If and TODAY function.
I am trying to pull data from an inventory tab to a new tab on my spreadsheet. We currently use a working sheet for inventory where the manager counts inventory everyday and then that sheet is saved ...
instead of TODAY() reference a different cell like $A$1 and then either type the day in cell A1 or use CTRL-; to automatically insert today's date.