View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
smartin smartin is offline
external usenet poster
 
Posts: 915
Default To get exact date

deepak wrote:
Hi!

How to know which date will it be after 5 years from today?

Suppose, A1=7-Aug-2005, so what will be the way to know which day and month
will it be after 5 yers from the given in date A1?

Thanks.

Deepak


Your question suggests "7 August" might not be correct. What result are
you expecting?