View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jen_T Jen_T is offline
external usenet poster
 
Posts: 66
Default First Day of the month

Does anyone know how to have excel look at a cell that has a date that is
formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as
01/01/2007 in B2, another words view as date as first day of the month.