Thread: Date Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default 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