Thread: Date Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default Date Formula

=TEXT(A1,"mmmm")
=DAY(A1)
=YEAR(A1)

Vaya con Dios,
Chuck, CABGx3



"JR" wrote:

Hello,

Will someone help me out with the formulas that will pull out the month,
then day, then year from a date. For example:

From todays date

3/22/06

I would like to return:

A5: March
A6: 22
A7: 2006

Thanks