Hi, I would like to be able to determine the previous quarter from the current date and display as Q2 or Q3 or Q4 etc.<o
></o
>
<o
> </o
>
I have the code to find and display the previous month (see below) but am unable to find a similar one for quarter. Thanks in advance.<o
></o
>
<o
I have the code to find and display the previous month (see below) but am unable to find a similar one for quarter. Thanks in advance.<o
Code:
Range("A4") = Format(DateAdd("m", -1, Date), " mmm yy")