date formating

N

Neda

hi
I am using the date formula for a series of dates, but when it changes the year I get #num!
That happens only on that one sheet, so I think is the way those cells are formated. Any suggestions about what may be the problem? Thanks.
 
J

JE McGimpsey

Formatting has nothing to do with errors. The #NUM! error indicates that
one or more of the arguments to the date function is invalid.
 
F

Frank Kabel

Hi
in addition to JE's answer you may simly post your existing formula
together with some example data

--
Regards
Frank Kabel
Frankfurt, Germany

Neda said:
hi,
I am using the date formula for a series of dates, but when it changes the year I get #num!.
That happens only on that one sheet, so I think is the way those
Click to expand...
cells are formated. Any suggestions about what may be the problem?
Thanks.
 
Top