month worksheet function returns wrong value
Hi!
You need to test cell A1 and make sure there is a date entered:
=IF(ISNUMBER(A1),MONTH(A1),"")
Or, maybe something like this:
=ISNUMBER(A1)*MONTH(A1)
Will return either 0 or the month number
Biff
"Barry" wrote in message
...
using formula =month(a1) and in a1 is a date of 01 01 2006 and it returns
value of 1 which is correct, however if i delete the date in a1 it still
returns a value of 1. how can I resolve this?
|