how to convert a date to a quarter Solved

Question

Hello,  How to convert a date into a quarter  Ex: Jan = Q1

DjiDji59430 · Accepted Answer

Hello,  =IF(MONTH(G1)

-L0Lock- · Answer

Hello. I find it hard to see how you can do that. A quarter is a given time interval, while a date is a precise point in that time.

However, you can define a quarter and ask Excel to determine which quarter a given date falls into.

If I have any complaints about your post, check out my profile and read the Quote/Proverb section, it will help you.

maryval33650 · Answer

=ROUND((MONTH(A2)+2)/3)" Trim. ""&YEAR(A2)

JvDo · Answer

Good evening everyone,

or for the Gibis:

=ROUND((-MONTH(A2)^11)/246400+(13*MONTH(A2)^10)/44800+(-7*MONTH(A2)^9)/768+(741*MONTH(A2)^8)/4480+(-21489*MONTH(A2)^7)/11200+(95147*MONTH(A2)^6)/6400+(-139943*MONTH(A2)^5)/1792+(619177*MONTH(A2)^4)/2240+(-1026879*MONTH(A2)^3)/1600+(1293669*MONTH(A2)^2)/1400+(-169942*MONTH(A2))/231+243,0) & " Trim. "&YEAR(A2)

best regards

L@urent69 · Answer

Here is without needing a cell with today's date: =IF((MONTH(TODAY()))

PHILOU10120 · Answer

Hello

Another idea

=CHOOSE(MONTH(TODAY());"Quarter1";"Q-1";"Q-1";"Q-2";"Q-2";"Q-2";"Q-3";"Q-3";"Q-3";"Q-4";"Q-4";"Q-4")

--
It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - one always learns from their mistakes.

How to convert a date to a quarter

6 answers

No access to my ubisoft account

Explode query

Caution: redirects at spartoo (300 eur)

Unrecognized product information

How to back out with cdiscount

Thunderbird password connection not possible

Antivirus problem

Unable to scan

Wrong keystrokes

I wanted to turn on my windows pc but i lost my product key