Saturday, January 4, 2014

Formula to determine Quarter from Date

Excel formula to get Quarter from date:

="Q"&INT((MONTH(BG2)/4)+1)&"-"&RIGHT(YEAR(BG2),2)

No comments:

Post a Comment