formatting

[joe@malvern]

need some help. formated a data entry date range 00/00/00 and when I use the
MONTH function it returns 1-12 correctly through the range except if a cell
in the range is blank then it returns a 1. how do I get it to return a blank
for blank cells?

thanks in advance

 

[Mike H]

Try

=IF(A1<>"",MONTH(A1),"")

Mike

 

[joe@malvern]

worked! thanks!

Try

=IF(A1<>"",MONTH(A1),"")

Mike