Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
Decide comment format 'globally'? Restore format with ws_change? | Excel Discussion (Misc queries) | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel |