View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Boyertown Casket[_2_] Boyertown Casket[_2_] is offline
external usenet poster
 
Posts: 18
Default ELAPSED TIME BETWEEN TWO DATES

I am sorry if this is a repost - my earlier post did not seem to be processed.

I have DATE OF BIRTH in cell A1 and DATE OF DEATH in Cell B1. I would like
to place the elapsed time in Cell C1. The format for Cell C1 would be: 79
Years 6 Months 3 Days. How would I write the formula?

Any help you can give me to accomplish this would be appreciated.

Thank you.

Jerry