Calculate date
Hi Viktor
If you have the Analysis Toolpak loaded, (ToolsAddinsAnalysis Toolpak) then
=EOMONTH(A1,B1-1)
Regards
Roger Govier
viktor wrote:
hi,
how can i calculate the end date(mm/yyyy) betwen one cell where i have a
date(dd/mm/yyyy) and in another cell i have a number of month(12)
ex: A1: 01/01/2005 B1: 12 in C1 i should obtain 12/2005
Thanks
|