ExcelBanter - formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formatting (https://www.excelbanter.com/excel-worksheet-functions/225840-formatting.html)

joe@malvern[_2_]

formatting

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

formatting

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

joe@malvern[_2_]

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

All times are GMT +1. The time now is 06:07 AM.