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 réponses

Big fish games are they worth it?

Saracroche: the effective french app against phone spam

How to get the character µ on the android keyboard.

Texture issues in enshrouded

Access issue to my "contact me" profile

Windows spotlight is not working.

Black screen digital camera

Connecting rj45 cable with fiber

Sony bravia tv red led blinks 4 times

Free: associating with the freebox server in progress