Need Help with a MONTH Formula

[bjh894]

Column A is for dates only. Column B is the number of the month associated with the date in A.

A1 is : 09/15/14
B1 is : 9


I understand I can use MONTH(A1) as a formula in B1, but how do I write the formula so it returns the number 0 if the month field is left blank?

In short, I have 500 rows, and not all rows have a date in Column A. The aforementioned MONTH(A1) formula wants to give a default answer of 1, which will not work for me when I later write my SUMIF formula to determine how any entries I have for the month of January.

Any help would be greatly appreciated.

Brian

 

[Michael M]

Try

=IF(A1="",0,Month(A1))

 

[bjh894]

Michael M.... THANK YOU ! I acknowledge you for your simple act of gratitude. I appreciate you.

 

[Michael M]

Pleasure...