How to convert a date to a quarter

Solved
maryval33650 Posted messages 9 Status Membre -  
 Gio -
Hello,

How to convert a date into a quarter

Ex: Jan = Q1

6 réponses

DjiDji59430 Posted messages 4277 Registration date   Status Membre Last intervention   716
 
Hello,

=IF(MONTH(G1)<=3,1,IF(MONTH(G1)<=6,2,IF(MONTH(G1)<=9,3,4)))

the date is in G1

There must be something more elegant!
2
Gio
 
There may be more elegant solutions, but at least this one works :-)
0