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.
Hi
Probably not what you expect* as I don't understand what you exactly mean with "and count weekdays going forward":
="As of " & TEXT( TODAY(),"ddd mm/dd/yy" )* Post an example of the expected result