| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding a date up to the 1st of the next month
I have a date in A1, but I need to populate A2 with the first day of the
following month. Example: A1 = 05/17/08, A2=06/01/08 What formula would best work to accomplish this? I'm guessing this would be easy, but I can't get anything to work. Thank you in advance for any assistance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding a date up to the 1st of the next month
If you have the Analysis ToolPak add-in installed:
A2: =EOMONTH(A1,0)+1 If you don't.... A2: =DATE(YEAR(A1),MONTH(A1)+1,0)+1 Does that help? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "hurds999" wrote in message ... I have a date in A1, but I need to populate A2 with the first day of the following month. Example: A1 = 05/17/08, A2=06/01/08 What formula would best work to accomplish this? I'm guessing this would be easy, but I can't get anything to work. Thank you in advance for any assistance. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding a date up to the 1st of the next month
Thank you both very very much. The formula(s) worked!! You're both very
awesome!!! Have a great Wednesday, because you've made mine!!! =) "Ron Coderre" wrote: If you have the Analysis ToolPak add-in installed: A2: =EOMONTH(A1,0)+1 If you don't.... A2: =DATE(YEAR(A1),MONTH(A1)+1,0)+1 Does that help? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "hurds999" wrote in message ... I have a date in A1, but I need to populate A2 with the first day of the following month. Example: A1 = 05/17/08, A2=06/01/08 What formula would best work to accomplish this? I'm guessing this would be easy, but I can't get anything to work. Thank you in advance for any assistance. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding a date up to the 1st of the next month
You're very welcome.
Regards, Ron Microsoft MVP (Excel) "hurds999" wrote in message ... Thank you both very very much. The formula(s) worked!! You're both very awesome!!! Have a great Wednesday, because you've made mine!!! =) "Ron Coderre" wrote: If you have the Analysis ToolPak add-in installed: A2: =EOMONTH(A1,0)+1 If you don't.... A2: =DATE(YEAR(A1),MONTH(A1)+1,0)+1 Does that help? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "hurds999" wrote in message ... I have a date in A1, but I need to populate A2 with the first day of the following month. Example: A1 = 05/17/08, A2=06/01/08 What formula would best work to accomplish this? I'm guessing this would be easy, but I can't get anything to work. Thank you in advance for any assistance. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding a date up to the 1st of the next month
=DATE(YEAR(A1),MONTH(A1)+1,1)
-- Gary''s Student - gsnu200777 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| rounding off month | Excel Worksheet Functions | |||
Hybrid Mode
