blank cells showing up as a month 1

C

Carl

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

Bob Phillips

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