| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
blank cells showing up as a month 1
Hi,
Trying to use the Month function to reference a leaving date column (for use with a pivot chart). However if this leaving date is blank the Month field still returns a 1 - anyway to stop this? (dates refererred to are dd/mm/yyyy format or blank). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
| showing blank cells | Excel Discussion (Misc queries) | |||
| Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
| In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
Threaded Mode
