Forum Discussion
Expiry date (12/31/202X) triggered by unknown start date (XX/XX/202X) of that year
Dear Community, Retired Civil Engineer, working on a spreadsheet whose license, when activated (i.e. 04/15/202X) will expire at calendar's year-end, 12/31/2X. I have successfully tested and p...
First reply didn't seem to post @ 0830 my time.
Received the following Run-time error '438' (see attachment "Error Msg.")
Also attached a worksheet Code 2 copy of the revised syntax/code as instructed.
If it matters, I'm using Windows 10, MS Office v.18.2008.12711.0, MS Excel Office Home and Student 2019.
Does it matter what date format I use? I personally use 17 Dec 2020, but for the spreadsheet, cell D1, I used 12/17/2020.
Thanks, ProTee
Using FORMAT is an optional but is a good practice,, please share the WB with us and let me check it, to fix the error!