J
john_mc
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
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