M
Mally
Hi
I have a list of dates in column C e.g. 01/10/2008
Column D equals the dates in column C and are formatted using the custom
'mmm' e.g. Oct
What I need is a formaula in column E that shows
If D1=Apr, May or Jun then the formula result displays "Q1"
OR
If D1=Jul, Aug or Sep then the formula result displays "Q2"
OR
If D1=Oct, Nov or Dec then the formula result displays "Q3"
OR
If D1=Jan, Feb or Mar then the formula result displays "Q4"
The formaula will be copied down the column
Thank you in advance.
I have a list of dates in column C e.g. 01/10/2008
Column D equals the dates in column C and are formatted using the custom
'mmm' e.g. Oct
What I need is a formaula in column E that shows
If D1=Apr, May or Jun then the formula result displays "Q1"
OR
If D1=Jul, Aug or Sep then the formula result displays "Q2"
OR
If D1=Oct, Nov or Dec then the formula result displays "Q3"
OR
If D1=Jan, Feb or Mar then the formula result displays "Q4"
The formaula will be copied down the column
Thank you in advance.