If formula using dates and texts [Closed]

Report
Posts
1
Registration date
Tuesday April 22, 2014
Status
Member
Last seen
April 22, 2014
-
Posts
1842
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 27, 2020
-
I want to write a formula which will show either Q1, Q2 Q3 or Q4 depending on the date I the next cell (written as 01/01/2014).

1 reply

Posts
1842
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 27, 2020
136
Maxbats, Good evening.

One possible way to achieve this, may be through the formula below.

A1 --> Date

B1 --> =IF(MONTH(A1)>=10,"Q4", IF(MONTH(A1)>=7,"Q3", IF(MONTH(A1)>=4,"Q2","Q1")))

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão