View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default How can I find out what date going to be 3 month from today in ex

=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))
=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))
--
David Biddulph

"Shahin Khan" <Shahin wrote in message
...
If today is 08 NOV 2008 after Three or six months later what date going to
be. How can I create a function in MS Excel. Can you please let me know.

My e-mai is

or


Thanks,

Shahin Khan