View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JP JP is offline
external usenet poster
 
Posts: 103
Default 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