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

 All Forums
 Other Forums
 Other Topics
 Excel Dates

Author  Topic 

MMJ146
Starting Member

1 Post

Posted - 2013-02-13 : 13:23:23
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
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-13 : 14:28:39
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

5 Posts

Posted - 2013-02-18 : 12:32:55
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/
Go to Top of Page
   

- Advertisement -