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