Date Formula

[JR]

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 today’s date

3/22/06

I would like to return:

A5: March
A6: 22
A7: 2006

Thanks

 

[Ardus Petus]

A1: =TODAY()

A5: =MONTH(A1)
A6: =DAY(A1)
A7: =YEAR(A1)

HTH

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3