emartinez391
New Member
- Joined
- Jul 8, 2015
- Messages
- 1
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.
<tbody>
</tbody>
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>