Thread: Date round-up
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Date round-up

Hi, is there an Excel function where we could round-up the date to 1st day of
the following month. For example

Cell A1 is 2006/08/25. I need cell B1 to be tabulated automatically to be
2006/09/01.
If cell A2 is 2006/11/11, cell B2 will be 2006/12/01.

Thanks for you support.

Jeff