| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Round to nearest month
Hi all. I need a function that can take a date, no matter what date in that
month, and round to the first of the next month. So for example if the cell has 1/4/07 I want the result to say 2/1/07 Or 1/1/07 would return 2/1/07 Thanks! Jp |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Round to nearest month
=DATE(YEAR(A1),MONTH(A1)+1,1)
-- Kind regards, Niek Otten Microsoft MVP - Excel "Jp" wrote in message ... | Hi all. I need a function that can take a date, no matter what date in that | month, and round to the first of the next month. | | So for example if the cell has 1/4/07 I want the result to say 2/1/07 | Or 1/1/07 would return 2/1/07 | | Thanks! | | Jp |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to round up to the nearest five | Excel Discussion (Misc queries) | |||
| How can I Round up to the nearest .25 | Excel Discussion (Misc queries) | |||
| How can I Round up to the nearest .25 | Excel Discussion (Misc queries) | |||
| How do I round to the nearest 5? | Excel Worksheet Functions | |||
| How do I round to the nearest $250 | Excel Worksheet Functions | |||
Hybrid Mode
