View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default Simple Question, display only part of a date in Number format

Hi Sunny

Or you could simplify it to just =DAY(A1)

--
Regards

Roger Govier


"DB Explorer" wrote in message
oups.com...
Thanks Andy, this works perfectly, fine.

Sunny