Thread: Formula to subtract a date from current date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davesexcel
 
Posts: n/a
Default Formula to subtract a date from current date

=ROUND((B15-A15)/365.25,0)
just subtract the two cells and round it to the nearest whole number
Dave


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=516761

Reply With QuoteReply With Quote