Guanjin Peter
Active Member
- Joined
- May 21, 2008
- Messages
- 429
I'm currently using the below code to check if it's blank. Actually I wanted to check if it is a valid date. I can't really use:
=IF(B1=dd-mm-yyyy,TEXT(WEEKDAY(B1),"dddd"),"")
so any idea?
=IF(B1=dd-mm-yyyy,TEXT(WEEKDAY(B1),"dddd"),"")
so any idea?
Code:
=IF(B1="","",TEXT(WEEKDAY(B1),"dddd"))