View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott
 
Posts: n/a
Default Changing today's date to the first of the month

Is there a function in Excel to change a date to the first of the month,

ie. =FIRSTDAY(Now()) to change 12/22/2005 to 12/1/2005

thanks.