formatting
worked! thanks!
"Mike H" wrote:
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
|