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.”
Date and Time
Userlevel 2
+8
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.