Round to nearest month

[Guest]

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

 

[Niek Otten]

=DATE(YEAR(A1),MONTH(A1)+1,1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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