I have a spreadsheet with this year's and previous year's data. I need to have the last day of the month pulled into a specific cell so the rest of my formulas work. Instead of inputting this years date and last years date, I would like to dumb it down so only one date needs to be changed. The formula I am using is =DATE(YEAR(B5),MONTH(B5)-12,DAY(B5)). B5 = Current Month End Date (i.e. 2/29/2012) The issue arises when the current year's date is a leap year (i.e 2/29/2012). This formula pulls in 3/1/2011. I need it to pull in 2/28/2011. I need this formula to work for both leap year and non leap year so the other users don't have to think too hard and do too much work. So if there is something that can be done where it will pull in the last date of the current month please let me know.