Next Due Date

[emartinez391]

Hi guys,
I'm kind of an Excel Noob and have been struggling with this for a couple of days I hope someone can help.

I have a spreadsheet used to track "Visit Due Dates". There are 4 visits required a year 1 annual and 3 quarterlies, all based on an "Approval Date". I would like to find a way to have the "Next Due" cell look at the 4 visit due columns and display the month of the next visit due regardless
of with colunm it is in.

I hope this makes sense. Any help would be greatly appreciated.

Approval Date	Annual Visit Due	1st Qrtly Vist Due	2nd Qrtly Vist Due	3rd Qrtly Vist Due	next due
7/13/14	July	October	January	April

<tbody>
</tbody>

 

[timfritsch]

If you have the analysis toolpack installed, and assuming the next due date empty cell is F2, the formula is =TEXT(EDATE(DATEVALUE(E2 & 1),3),"mmmm")

DATEVALUE converts the text month into a numerical date
EDATE allows for addition/subtraction of months
TEXT converts the result into the month name

Hope this helps.


Tim