MLSNetworks
New Member
- Joined
- Jun 6, 2019
- Messages
- 17
Hello Friends,
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!
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!