View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gautam
 
Posts: n/a
Default how to split the cell which has the date formula (with day)

Hi,
i want to know if i have a cell with the date format, in which they show the
day, & month, like:
Monday, December 12, 2005
its a formatted cell,
now if i want to pull the day in a diff. cell, what is formula for that
pls. give me some solution for that

Regards
Gautam