Formula from date to quarter
Please HELP!! I've been trying to figure this out for days! I'm trying to create a formula that will display quarter names (Quarter 1, Quarter 2, Quarter 3, Quarter 4) based on two fields [Meeting Ty...
Forum Discussion
If((Month(Today())>0 and Month(Today())<4),1,
If((Month(Today())>3 and Month(Today())<7),2,
If((Month(Today())>6 and Month(Today())<10),3,
If((Month(Today())>9 and Month(Today())<13),4,
0))))
If((Month(Today())>3 and Month(Today())<7),2,
If((Month(Today())>6 and Month(Today())<10),3,
If((Month(Today())>9 and Month(Today())<13),4,
0))))
