Forum Discussion

BobF77845's avatar
BobF77845
Copper Contributor
Dec 27, 2023
Solved

Custom date format

After setting the custom date format to mm/yy I typed 7/26 (for 2-digit month and 2-digit year) and expected to see 07/27, instead I get 07/23. What's wrong?

  • SOLVED Just format as Number: 00/00 and entering 7/26 will yield 07/26. Even though I am entering a date, it must be entered as a number.

1 Reply

  • BobF77845's avatar
    BobF77845
    Copper Contributor
    SOLVED Just format as Number: 00/00 and entering 7/26 will yield 07/26. Even though I am entering a date, it must be entered as a number.