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.
| 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, 2014MMedit: 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. |
 |
|
|
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/ |
|
|
|
|
|
|
Excel Dates