excel formular to calculate Monthly,Quartely,Semi annually and Anually from last date.

Posted on 2014-03-04
Last Modified: 2014-03-04
Is there an expert that can provide me with the formula in excel to calculate the next payment date based on Monthly,Quartely,Semi annually and Anually from last date.


Last date              Frequency      Next Date
04/03/2014      1      04/04/2014
04/03/2014      3      04/06/2014
04/03/2014      6      04/09/2014
04/03/2014      12      04/03/2015

Many thanks
Question by:Jagwarman
LVL 49

Accepted Solution

Rgonzo1971 earned 500 total points
ID: 39903346

pls use

=EDATE(date, Months)

Open in new window


Author Closing Comment

ID: 39903372

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
.Range Set 25 78
Excel Conditional Median Problem 1 15
VBA Works in Excel 2010 Not 2016 Help! 5 20
Excel Formula 16 46
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question