Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MONTH function where cell is blank
I am trying to create a formula whic will allow me to count how many things
happened in a particular month. I have successfully got the formula to scan the worksheet to return the month code (which I then run a second formula across to count the occurrences). The problem I have is that when Excel encounters a blank cell it returns a month value of "1" (I assume this is the default date of 1-Jan-1900). How do I stop this? I would ideally like to return a message "date not found" in this instance. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Force date cell to show [blank] if end of month | Excel Discussion (Misc queries) | |||
Formula/Function to insert month by name in a cell | Excel Worksheet Functions | |||
IF function for blank cell | Excel Worksheet Functions | |||
When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
If Function: Blank cell and 0 (zero) seem to have same "value" | Excel Worksheet Functions |