SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 Other Topics
 Excel Dates
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

MMJ146
Starting Member

USA
1 Posts

Posted - 02/13/2013 :  13:23:23  Show Profile  Reply with Quote
What excel formula can I use to calculate a maturity date by having a specific date in cell A1, and a number that will represent how many months to calculate forward in cell A2, with end date result in cell A3?

Example: February 1, 2013 12 January 1, 2014

MM

edit: Moved to other forum. Don't even know why this ended up on this site.

James K
Flowing Fount of Yak Knowledge

3744 Posts

Posted - 02/13/2013 :  14:28:39  Show Profile  Reply with Quote
One of these:
=EDATE(A1,B1-1)
=DATE(YEAR(A1),MONTH(A1)+B1-1,DAY(A1))

This (Script Library) is probably the wrong forum - hope one of the moderators will move it to a more appropriate forum.
Go to Top of Page

markspend1
Starting Member

Australia
5 Posts

Posted - 02/18/2013 :  12:32:55  Show Profile  Reply with Quote
Hey Guys i think that for setting the date range on excel you should able to perform the calculations
just like others.For such performing its necessary to identify a due date like a start date and also the no of days in a date range of excel.You should using "-" and "+" for calculating the range period finishing date.Thanks a lot!!

http://www.roguevisions.com/

Edited by - markspend1 on 01/09/2014 02:08:41
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000