Skip to main content

BOB back again, I’ve recently tried to state a if statement with Date = Date. I have excel pulling a date out of its spreadsheet listed as something like 6/1/2024, When I use this if statement I have it see if that date matches the current system date. When formatting the date I use MM/dd/yyyy, it throws this error for me: “The target date/date time format has been entered incorrectly. Please enter a valid date value/format value.”

Hi, Please try using the date format as M/d/yyyy.

MM/dd/yyyy

    •    MM: Month with two digits (01 for January, 11 for November)
    •    dd: Day with two digits (05 for 5th, 15 for 15th)
    •    yyyy: Year with four digits (2024)

Example: June 1, 2024 is 06/01/2024.

M/d/yyyy

    •    M: Month with one or two digits (1 for January, 11 for November)
    •    d: Day with one or two digits (5 for 5th, 15 for 15th)
    •    yyyy: Year with four digits (2024)

Example: June 1, 2024 is 6/1/2024.

 

Mark this response as solution if it helps you.


Reply