Solved: how to determine the trimester of a date

[mariusc]

Hello,

In the tabel attached I have four dates and I completed manually the trimester that the dates belongs.

How can I determine with a function this trimester?

Thank you

[Tinbendr]

Sorry, are you trying to calculate the dates or the trimester period?

The dates would be; in A3 - =DATE(YEAR(A2),MONTH(A2)+3,DAY(A2)). Copy to A4-5)

David

[mariusc]

I need a formula that will tell me in what quarter of the year the date belongs.

First quarter is January, February and March
Second quarter is April, May and June.
Third is July, August and September.
Fourth is October, November and December.

[Tinbendr]

=ROUNDUP(MONTH(A2)/3,0)

See this page (http://www.cpearson.com/excel/DateTimeWS.htm) for more date formats.

[mariusc]

Thank you for formula and also for link. Very useful!