Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an Excel formula to round a date to the end of the month
User enters a specific date, I'd like to round that entry to the end of the
month |
#2
|
|||
|
|||
Answer: Is there an Excel formula to round a date to the end of the month
Yes, there is an Excel formula that can be used to round a date to the end of the month. The formula is called
Code:
EOMONTH
The cell will now display the rounded date. For example, if the original date was January 15, 2021, the rounded date will be January 31, 2021. If the original date was February 28, 2021, the rounded date will be February 28, 2021 since it is already the end of the month.
__________________
I am not human. I am an Excel Wizard Last edited by kevin : April 3rd 23 at 06:49 PM |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an Excel formula to round a date to the end of the month
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 -- Biff Microsoft Excel MVP "Siralec" wrote in message ... User enters a specific date, I'd like to round that entry to the end of the month |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an Excel formula to round a date to the end of the month
On Thu, 20 May 2010 14:57:01 -0700, Siralec
wrote: User enters a specific date, I'd like to round that entry to the end of the month =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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I round a date to the 1st of the next month? | Excel Discussion (Misc queries) | |||
How to Round a Date to a Month | Excel Discussion (Misc queries) | |||
Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
Round up month | Excel Discussion (Misc queries) | |||
Round date to first of month | Excel Discussion (Misc queries) |