Is there an Excel formula to round a date to the end of the month
With a date in A1:
=DATE(YEAR(A1),MONTH(A1)+1,0)
step into the next month and then back one day.
--
Gary''s Student - gsnu201003
"Siralec" wrote:
User enters a specific date, I'd like to round that entry to the end of the
month
|