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