Hi,

You may try this. D5 has the date. E5 has 11. Please note that for the
EDATE function to work, you will have to install the Analysis Toolpak from
Tools Adins

=EDATE(D5,E5)+1

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"pk" wrote in message
...
How can I calculate 11 months and 1 day from a given date using an excel
2003
function?