Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

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

Starting Member

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


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

James K
Flowing Fount of Yak Knowledge

3873 Posts

Posted - 02/13/2013 :  14:28:39  Show Profile  Reply with Quote
One of these:

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

Starting Member

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!!

Edited by - markspend1 on 01/09/2014 02:08:41
Go to Top of Page
  Previous Topic Topic Next 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.02 seconds. Powered By: Snitz Forums 2000