View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Finding date of the month

the dates of the month in cell a1?

How is the month entered in the cell?

As the month name as a TEXT entry: January or Jan

As a true Excel date: 1/1/2008

As the number of the month: 1

???

--
Biff
Microsoft Excel MVP


"Esra" wrote in message
...
anybody got any ideas how i can display a lit of dates in cells a2:a32
that are the dates of the month in cell a1?