Try

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

Mike

"joe@malvern" wrote:

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