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

Test for blank as well, because it is been treated as zero, 1/1/1900, which
is month 1.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Carl" wrote in message
...
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).