Some of you may remember an Excel feature that we wrote about a while back, which explained how the DATE function will convert invalid dates into real ones. For example, DATE(2020,7,35) will be converted to August 4, 2020, since there are not 35 days in July.
Here is where the fun begins!
- This week includes the 21st day of the month of September
- September is the 9th month of this year, which is also the 21st month of last year
- Last year was 2021
Put this all together and we have another special event happening this week …
On September 21, 2022,
the resulting date will be 21/21/21
And if we take it a step further …
At 9:21p and 21 seconds on 9/21/2022,
the resulting time will be 21:21:21 on 21/21/21
This is why we love Excel!
Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!
Read more IBM Planning Analytics Tips & Tricks:
IBM Planning Analytics Tips & Tricks: Creating Control Objects from the Modeling Workbench
IBM Planning Analytics Tips & Tricks: Garbage Memory
IBM Planning Analytics Tips & Tricks: Shortcuts in PAW Models
