need help with format

J

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
 
D

Dave Peterson

I'm not sure what you really have in that cell, but maybe:

If the cell (A1) is empty:
=if(a1="","",month(a1))

If the cell really contains 00/00/00 (actually 00/00/1900)
=if(a1=0,"",month(a1))
 
Top