View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Manos Manos is offline
external usenet poster
 
Posts: 50
Default Date Formulas & format

Dear all

I have in cell A1 the formula =NOW(), in order to have the currnet date.
I want ot split in A2, A3, and A4 the date, month and year resprectivly, and
in format of date, month & year
eg: A1- 02/08/2007
i want in A2 02, A3-August, A4-2007,

What can i do and what type of format should i have in A3 in order to see
August instead of 08.

Thanks in advance
Manos