Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Trending Formula Results by Date | Excel Worksheet Functions | |||
Year-to-date year to date formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |