Forum Discussion
Weekday formula
This formula ="As of "&TEXT(WEEKDAY(TODAY()),"mm/dd/yy") is producing a 01/02/1900 issue. How do I correct to reflect today's date (10/20/25) and count weekdays going forward, thank you.
In addition and as a comment. In your formula you first take weekday for the current date which was Oct 20, 2025. It returns number 2. Next, you present this number 2 as the date. In Excel dates are actually sequential integers starting from Jan 01, 1900 which is equal to 1. Thus number 2 as the date is Jan 02, 2005. If to continue, Oct 20, 2025 is the same as 45950.