?
Solved

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

Posted on 2014-03-04
2
Medium Priority
?
305 Views
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.

i.e.

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
0
Comment
Question by:Jagwarman
2 Comments
 
LVL 54

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 39903346
Hi

pls use

=EDATE(date, Months)

Open in new window

Regards
0
 

Author Closing Comment

by:Jagwarman
ID: 39903372
excellent
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

850 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