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.

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

<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.

 

[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?