I have a spreadsheet that uses dates and date functions aplenty.
For an example. The current date is March 30th. I would like to test what my spreadsheet is going to do when the current date is April 1st.
What I want to do is have Calc think I changed the PC’s date without really changing the PC’s date.
Introduce a reference cell and reference that cell from all the other cells where you use the TODAY() function. Then change the =TODAY() formula to any constant value you want to test.
Save a backup of your document and try the following replacement where $Sheet.$A$1 is the absolute reference to your reference cell.
1 Like
I mean yes, I knew I could do that. I was hoping for something a little easier. I am weak and lazy.
That worked of course and was much easier than I thought. Thanks.