Hi, Is there a way I can test the contents of a cell to see if it is a date? Thanks.
K Karen53 Jul 15, 2006 #1 Hi, Is there a way I can test the contents of a cell to see if it is a date? Thanks.
B Biff Jul 15, 2006 #2 Hi! You can use this: =ISNUMBER(A1) Dates are really just formatted numbers. So, a cell that contains a number will also evaluate the same as a date entry: 7/15/2006 10 Using ISNUMBER, both will evaluate to TRUE. (provided that the DATE entry is a real Excal date and not TEXT) Biff
Hi! You can use this: =ISNUMBER(A1) Dates are really just formatted numbers. So, a cell that contains a number will also evaluate the same as a date entry: 7/15/2006 10 Using ISNUMBER, both will evaluate to TRUE. (provided that the DATE entry is a real Excal date and not TEXT) Biff
B Biff Jul 15, 2006 #4 You're welcome. Thanks for the feedback! Biff Karen53 said: thanks, Biff. The answer you gave me the other day helped a lot too. Click to expand...
You're welcome. Thanks for the feedback! Biff Karen53 said: thanks, Biff. The answer you gave me the other day helped a lot too. Click to expand...
