Thread: How do I find the length of time (Years & Months) between 2 dates
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default How do I find the length of time (Years & Months) between 2 da
One way:

A1: <date inducted
A2: <date to be replaced
A3: =A2-A1

format A3 as General or Number.

No idea how to update it daily unless you specify how either of the
dates change.


In article ,
Brandon wrote:

I have a spreadsheet with a date inducted and a date it needs to be replaced.
How do I get a cell with the remaining days between the dates and it update
daily?
Reply With QuoteReply With Quote