Thread: dates count till elapsed
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
barry houdini[_4_] barry houdini[_4_] is offline
external usenet poster
  
Posts: 57
Default dates count till elapsed
Without Analysis ToolPak

=DATE(YEAR(A1)+5,MONTH(A1),DAY(A1))-TODAY()

format as general
Reply With QuoteReply With Quote