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

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 21, 2025

    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. 

  • 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