aravindhan_31
Well-known Member
- Joined
- Apr 11, 2006
- Messages
- 672
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi,
I need your help for a formula,
in cell A1 i have the value 10/01/2015 ( oct 10 2015) ( different dates for about 1000 rows)
i want in column if the format is mm/dd/yyyy , for ex if the some else has entered format as 10/1/2015 then i want to highlight.
this formula is giving to true for both formats. =DATEVALUE(TEXT(A1,"dd/mm/yyyy"))
can someone help me plz
I need your help for a formula,
in cell A1 i have the value 10/01/2015 ( oct 10 2015) ( different dates for about 1000 rows)
i want in column if the format is mm/dd/yyyy , for ex if the some else has entered format as 10/1/2015 then i want to highlight.
this formula is giving to true for both formats. =DATEVALUE(TEXT(A1,"dd/mm/yyyy"))
can someone help me plz