I have something incorrect in my formula. If A3 is on the worksheet, I need it to pull the last day of the quarter end of the next month. For example if the date in D3 on my schedule is 12/11/2012, if it is not on the worksheet, it should calculate to 12/31/2012. If the value Is on the worksheet, I need it to calculate to 03/31/2013. Currently it is calculating 12/31/2011 regardless whether or not A3 is found on the worksheet tab or not.
=IF(ISNA(VLOOKUP(VALUE(A3),'worksheet'!B:E,3,FALSE)),EOMONTH(DATE(YEAR(D3),ROUNDUP(MONTH(D3)/3,0)*3,1),0),EOMONTH(DATE(YEAR(D3),ROUNDUP(MONTH(D3)/3,0)*3,1),0)+95-DAY(EOMONTH(DATE(YEAR(D3),ROUNDUP(MONTH(D3)/3,0)*3,1),0)+95))
Anyone know where the mistake lies? Thanks!
Bookmarks