Calculate date
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 |
Calculate date
=DATE(YEAR(A1),MONTH(A1)+12,DAY(A1))-1
Format Custom as "mm/yyyy" -- Kind regards, Niek Otten "viktor" wrote in message ... 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 |
Calculate date
Try the following:
=date(year(A1),month(A1)+B1,day(A1)) Given your example, you may need this: =date(year(A1),month(A1)+B1-1,day(A1)) "viktor" wrote in message ... 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 |
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 |
Calculate date
On Sat, 10 Dec 2005 04:59:02 -0800, 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 Hmmm, if add 1 month to 1 Jan 2005 I get to Feb 2005. If I add 12 months, I get to Jan 2006. If you have the Analysis toolpak installed, the easiest method is the function: =EDATE(A1,12) But depending on the result you want, you may need to subtract 1 from the 12. --ron |
All times are GMT +1. The time now is 07:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com