#### MLSNetworks

##### New Member

- Joined
- Jun 6, 2019

- Messages
- 15

I received an excel file with the following INT formula which I've never seen before and I was hoping someone could explain to me why this was used.

The formula is

**=YEAR(A3) & "-" & "Q" &INT((MONTH(A3)+2)/3)**and it is reading from a date in US format m/dd/yyyy (formatted in Format Cells as Date)

I understand first half of the formula but I don't understand why you would use INT (Integer) with the last part +2) /3)

Can someone explain to me?

Thank you!