S Siralec May 20, 2010 #1 User enters a specific date, I'd like to round that entry to the end of the month
G Gary''s Student May 20, 2010 #2 With a date in A1: =DATE(YEAR(A1),MONTH(A1)+1,0) step into the next month and then back one day.
T T. Valko May 21, 2010 #3 Another way... This requires the Analysis ToolPak add-in be installed for Excel versions prior to Excel 2007. A1 = some date =EOMONTH(A1,0) Format as Date
Another way... This requires the Analysis ToolPak add-in be installed for Excel versions prior to Excel 2007. A1 = some date =EOMONTH(A1,0) Format as Date
R Ron Rosenfeld May 21, 2010 #4 User enters a specific date, I'd like to round that entry to the end of the month Click to expand... =A1-DAY(A1)+32-DAY(A1-DAY(A1)+32) If it needs to be done in the SAME cell as the entry, you could use a VBA Event triggered macro. --ron
User enters a specific date, I'd like to round that entry to the end of the month Click to expand... =A1-DAY(A1)+32-DAY(A1-DAY(A1)+32) If it needs to be done in the SAME cell as the entry, you could use a VBA Event triggered macro. --ron
