Prev: Copying Cells with Fill Handle
Next: GETPIVOTDATA and (blank)
From: Ashish Mathur on 26 Apr 2010 11:01
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" <pk(a)discussions.microsoft.com> wrote in message
news:9820FCC2-9414-4A5C-B168-E9B8B82E6848(a)microsoft.com...
> How can I calculate 11 months and 1 day from a given date using an excel
> 2003
> function?

First  |  Prev  | 
Pages: 1 2
Prev: Copying Cells with Fill Handle
Next: GETPIVOTDATA and (blank)