date formating

[Guest]

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.

 

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

 

[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

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.