View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan Susan is offline
external usenet poster
 
Posts: 271
Default How can I find out what date going to be 3 month from today in ex

enter the date in Cell (example A1)

Create this formula in (Example B1) =A1+182 (182 for 6 months or 91 for 3
months). This formula simply takes the date and adds a certain number of
days to it.

Make sure that both cells are formatted to Date format
--
Thanks!
Susan


"Shahin Khan" wrote:

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