need help with format
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))
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
--
Dave Peterson
|