Forum Discussion

mrwolfe64's avatar
mrwolfe64
Copper Contributor
Oct 20, 2025

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.

excel

2 Replies

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Oct 20, 2025

    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

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Oct 20, 2025

    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")

     

Resources