I am to make the date 5/1/2006 absolute and subtract it from another date
then divide by 365
Hope you can help me.
Lori
I am to make the date 5/1/2006 absolute and subtract it from another date
then divide by 365
Hope you can help me.
Lori
If you have two dates in A1 and B1, then you can enter this formula in
C1:
=ABS(A1-B1)/365
and format C1 as a number. This will give you the difference in the
dates in years (approximately, as there are 365.25 days in a year on
average).
Hope this helps.
Pete
It worked pete, can you help me with IF function I posted?
Lori
potsie wrote:
>I am to make the date 5/1/2006 absolute and subtract it from another date
>then divide by 365
>Hope you can help me.
>Lori
Glad it worked.
You seem to have answers already to your posts on the IF function.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks