Thread: Adding 10 years to a date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
NBVC[_30_] NBVC[_30_] is offline
external usenet poster
  
Posts: 1
Default Adding 10 years to a date

Try:


Code:
--------------------
=DATE(YEAR(A1)+10,MONTH(A1),DAY(A1))
--------------------


and


Code:
--------------------
=IF(AND(B1<=DATE(YEAR(TODAY())+10,MONTH(TODAY()),D AY(TODAY())),B1=DATE(YEAR(TODAY())-10,MONTH(TODAY()),DAY(TODAY()))),"within","outside ")
--------------------


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109811

Reply With QuoteReply With Quote