Godders199
Active Member
- Joined
- Mar 2, 2017
- Messages
- 313
- Office Version
- 2013
Hello, I am not sure if this is possible, but below is an example of a spreadsheet of 1000+ rows , Each row can have upto 3 dates in columns A-C. What i am looking to do is find the latest date in that row and in column D display the Quarter.
<colgroup><col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3620;">
<col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;">
<col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;">
<col width="64" style="width: 48pt;">
<tbody>
</tbody>
Is it possible to code this? Read my VBA book and cant find any examples.
Date 1 | Date 2 | Date 3 | Quarter |
01/01/2018 | 06/04/2018 | 01/03/2018 | Q2 |
07/06/2018 | 01/07/2018 | Q3 | |
01/01/2018 | Q1 |
Is it possible to code this? Read my VBA book and cant find any examples.