Thread: End of Quarter Function

Hello everyone, I need help creating a function to calculate the end of quarter for a given date after adding any number of months to that date. Example cell A1 would contain 01/15/2010. I want to add 6 months to A1. A2 would contain 6 making it 07/15/2010, B1 would contain a function that would display 09/30/2010. Any help would be greatly appreciated. FYI.... Using Excel 2007


Thanks,
Covershaker

One way:

A2: =EDATE(A1,6)
B1: =DATE(YEAR(A2),CEILING(MONTH(A2),3)+1,0)