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.
not sure why you have WEEKDAY in that formula but that is your problem;
="As of "&TEXT(TODAY(),"mm/dd/yy")
if the intent is that you only want to reply with weekdays (and not weekends) then you need to create a more complicated equation wit IF and determine what you want it to respond with if it is the weekend (i.e. give prior FRI or upcoming MON date?). For example I think the following will check for Sat/Sun and subtract that from the date before converting to text so it will show Fri date over the weekend:
="As of "&TEXT(TODAY()-MAX(0,WEEKDAY(TODAY(),2)-5),"mm/dd/yy")