Date Formula
 

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

Date Formula
 

A1: =TODAY()

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

HTH
--
AP

"JR" a écrit dans le message de
...
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

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