I presume weekends and holidays do not matter...

=DATE(YEAR(A1),MONTH(A1)+11,DAY(A1)+1)

--
Rick (MVP - Excel)



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