need help with format
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 |
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 |
All times are GMT +1. The time now is 03:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com