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