Month function
Posted by Joe on January 22, 2002 3:32 PM
How do I stop the Month function from evaluating a blank cell as 1.
Posted by on January 22, 2002 3:48 PM
=IF(A1="","",MONTH(A1))
Posted by IML on January 22, 2002 3:51 PM
=IF(A1,MONTH(A1),"")
Posted by Joe on January 22, 2002 3:32 PM
How do I stop the Month function from evaluating a blank cell as 1.
Posted by on January 22, 2002 3:48 PM
=IF(A1="","",MONTH(A1))
Posted by IML on January 22, 2002 3:51 PM
=IF(A1,MONTH(A1),"")
