View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
maybe
=INT(DATEDIF(A1,TODAY(),"y")/10)

"Saskia" wrote:


For an assignment I'm asked to calculate how many decades have elasped
since a particular date.

Can anyone help me with this formula


--
Saskia
------------------------------------------------------------------------
Saskia's Profile: http://www.excelforum.com/member.php...o&userid=15810
View this thread: http://www.excelforum.com/showthread...hreadid=273088