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.
[TABLE="class: grid, width: 443"]
<tbody>[TR]
[TD]Approval Date
[/TD]
[TD]Annual Visit Due
[/TD]
[TD] 1st Qrtly Vist Due
[/TD]
[TD] 2nd Qrtly Vist Due
[/TD]
[TD] 3rd Qrtly Vist Due
[/TD]
[TD]next due
[/TD]
[/TR]
[TR]
[TD]7/13/14
[/TD]
[TD]July
[/TD]
[TD]October
[/TD]
[TD]January
[/TD]
[TD]April
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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