If formula using dates and texts
Closed
Maxbats
Posts
1
Registration date
Tuesday April 22, 2014
Status
Member
Last seen
April 22, 2014
-
Apr 22, 2014 at 06:23 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Apr 22, 2014 at 09:17 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Apr 22, 2014 at 09:17 PM
Related:
- If formula using dates and texts
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Apr 22, 2014 at 09:17 PM
Apr 22, 2014 at 09:17 PM
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
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
