software

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 - quot;31/06/1948quot; / 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--
john_mc
------------------------------------------------------------------------
john_mc's Profile: www.excelforum.com/member.php...oamp;userid=32013
View this thread: www.excelforum.com/showthread...hreadid=531404Hi!

The problem is: quot;31/06/1948quot;

There is no June 31st so the quot;datequot; is being evaluated as a TEXT string.

Biff

quot;john_mcquot; gt; wrote in
message ...
gt;
gt; Hi All,
gt;
gt; this is driving me crazy...if anyone can help i'd be grateful.
gt;
gt; My formula is:
gt;
gt; =ROUND((I4 - MySheetY3) / 365,0)
gt;
gt; so i'm just trying to subtract one date from the other and then
gt; dividing by 365to get the rounded number of years difference
gt;
gt; However, this results in an #value error. The trace error shows:
gt;
gt; =Round (( 35828 - quot;31/06/1948quot; / 365, 0)
gt;
gt; When looking at the trace error bit, the first date (I4) is being taken
gt; as the serial number, not the date, whereas the date in Y3 is being seen
gt; as a date.
gt;
gt; So thinking it was a formating thing, I checked the cell formating and
gt; it is in a date format. I've tried deleting all the columns and
gt; starting again, painting formats, changing formats...everything!
gt;
gt; Any ideas?
gt;
gt; cheers, John
gt;
gt;
gt; --
gt; john_mc
gt; ------------------------------------------------------------------------
gt; john_mc's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32013
gt; View this thread: www.excelforum.com/showthread...hreadid=531404
gt;