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).