Excel — displaying date that is X months from today

Any easy way to do this? In VBA I'd normally use dateadd() but since this is Excel, I don't have that function.

Answers


The following function does the job:

=DATE(YEAR(A2),MONTH(A2)+B2,MIN(DAY(A2),DAY(DATE(YEAR(A2),MONTH(A2)+B2+1,0))))

For example:

Date       Add Months   Result  
8/1/2012   6            =DATE(YEAR(A2),MONTH(A2)+B2,MIN(DAY(A2),DAY(DATE(YEAR(A2),MONTH(A2)+B2+1,0))))

Result:

Date       Add Months   Result  
8/1/2012   6            2/1/2013

Need Your Help

Pythonic way of inserting lines to a file

python file-io insert

So as the description describes, I would like to add text to a file in a sequential manner. Say, for example I have a file like this (NOT HTML, this is just an imaginary language) lets call it

which (high performance) database with NHibernate?

c# .net database nhibernate

I have to develop a .NET-Application which has to store small data and should work with big performance. It should also be possible to do concurrent connections to the datastore. There will be the

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.