If formula using dates and texts
Closed
Maxbats
Posts
1
Registration date
Tuesday 22 April 2014
Status
Member
Last seen
22 April 2014
-
22 Apr 2014 à 18:23
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 22 Apr 2014 à 21:17
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 22 Apr 2014 à 21:17
Related:
- If formula using dates and texts
- Logitech formula vibration feedback wheel driver - Download - Drivers
- If formula for dates - Guide
- Iphone 14 release dates - Home - IOS
- Spreadsheet formula - Guide
- Vivatech 2024 dates - Guide
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
22 Apr 2014 à 21:17
22 Apr 2014 à 21:17
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
