Is there an Excel formula to round a date to the end of the month

G

Gary''s Student

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

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
converting dates from file 3
Expanding Date formula 2
Autofill Date in Word 15.33 for Mac 0
formula with text and rounding 2
Round up/down duration 0
Round formula 1
what do these ----> {0.6,2,4,5,6,7,9} and {0,21,111,201,551,1101,2701}means in an excel formula? 1

Top