This is giving me a headache, Please Help!!!
I've spent way too many days on this. I am trying to create a formula that will show the next payment date based on a number of given factors. First, the payment frequency. Second, the start date. Third, current date. In the example, column "D" needs to show when the next payment is due given the fact that it's the 9th of November. I can add extra columns if that helps.
Almost finish, except the condition "Every Other Month". What is your expected result for this?
Quang PT
Wow, that's looking great. I was especially having a hard time "Quarterly". To answer your question, Every other month would be like if it was last due on 11/2/15, the next payment would be 1/2/15, then 3/2/15, and so on. Also, I see that the formula for every six months has those special brackets, does that make it an array formula?
Thanks again,
So it means 2 month frequence:
=MAX(EDATE(C15,CEILING(DATEDIF(C15,$C$2,"m")+{1,2},2)))
Not at all. With {1,2}, EDATE returns result(1) and result(2), then MAX() to get the biggest.Originally Posted by sabin348
d17=EDATE(C17,CEILING(DATEDIF(C17,$C$2,"m")+1,6))
I think this will work for that
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thanks nflsales, it is simple and correct.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks