Hi All,

this is driving me crazy...if anyone can help i'd be grateful.

My formula is:

=ROUND((I4 - MySheetY3) / 365,0)

so i'm just trying to subtract one date from the other and then dividing by 365to get the rounded number of years difference

However, this results in an #value error. The trace error shows:

=Round (( 35828 - "31/06/1948" / 365, 0)

When looking at the trace error bit, the first date (I4) is being taken as the serial number, not the date, whereas the date in Y3 is being seen as a date.

So thinking it was a formating thing, I checked the cell formating and it is in a date format. I've tried deleting all the columns and starting again, painting formats, changing formats...everything!

Any ideas?

cheers, John