Error in formula =YEAR(B4)-YEAR(A4) gives me #Value
 

not sure if it helps, but it works fine for me ...

some ideas - right mouse click on both cells ensure that if you choose
format cells / "general" for A4 you see 25200 as the sample & 37133 for B4
- this will "prove" that they are dates and excel recognises them as such

what does =YEAR(A4) return when you try it on its own? what about =YEAR(B4)
?

let us know how you go

Cheers
JulieD


"Pasting column width and row heights"
soft.com wrote in message
...

A4 B4
12/28/1968 8/30/2001
These are the dates I am working with.