Select lastest date and convert to quarter

[Godders199]

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.

[TABLE="width: 244"]
<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>[TR]
[TD="width: 99, bgcolor: transparent"]Date 1[/TD]
[TD="width: 83, bgcolor: transparent"]Date 2[/TD]
[TD="width: 80, bgcolor: transparent"]Date 3[/TD]
[TD="width: 64, bgcolor: transparent"]Quarter[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]01/01/2018[/TD]
[TD="bgcolor: transparent, align: right"]06/04/2018[/TD]
[TD="bgcolor: transparent, align: right"]01/03/2018[/TD]
[TD="bgcolor: transparent"]Q2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent, align: right"]07/06/2018[/TD]
[TD="bgcolor: transparent, align: right"]01/07/2018[/TD]
[TD="bgcolor: transparent"]Q3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent, align: right"]01/01/2018[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]Q1[/TD]
[/TR]
</tbody>[/TABLE]

Is it possible to code this? Read my VBA book and cant find any examples.

 

[jmacleary]

Hi there. You don't need VBA for this. Building on the answer you received yesterday from GasNicki to your previous question about Quarter from Date, for row 4 put this formula in D4: ="Q"&ROUNDUP(MONTH(MAX(A4:C4))/3,0)

 

[footoo]

Here's a formula :
="Q" & ROUNDUP(MONTH(MAX(A1:C1))/3,0)

 

[footoo]

I've just looked at your post yesterday. If you really need VBA, have the code enter the formula in the required range and then convert to value.

 

[Godders199]

thanks all

 

[jmacleary]

You're welcome - which way did you go, formula or vba?