#1   Report Post  
Old December 10th 05, 01:59 PM posted to microsoft.public.excel.worksheet.functions
viktor
 
Posts: n/a
Default 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

  #2   Report Post  
Old December 10th 05, 02:18 PM posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default 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



  #3   Report Post  
Old December 10th 05, 02:21 PM posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt
 
Posts: n/a
Default 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



  #4   Report Post  
Old December 10th 05, 05:54 PM posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default 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

  #5   Report Post  
Old December 10th 05, 06:11 PM posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula to calculate age using birth date and current date lalah Excel Worksheet Functions 2 November 20th 05 11:51 PM
Calculate a biweekly date TimT Excel Discussion (Misc queries) 2 November 18th 05 06:03 PM
calculate the number of days from date received Donna Excel Worksheet Functions 7 July 18th 05 07:00 PM
calculate date differences in years and months Joyce Excel Worksheet Functions 1 March 14th 05 06:18 PM
How do I use the IF function to calculate date Pulling My Hair Out! Excel Discussion (Misc queries) 1 December 11th 04 12:03 AM


All times are GMT +1. The time now is 01:58 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017