| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing year portion of date
Thank you.
"ArthurJ" wrote: A B 1 3/1/2005 =year(A1)=A$5 False 2 10/5/2008 True 3 4/9/2003 False 4 5 2008 Enter the formula shown in cell B1 and copied it down. It will evaluate as shown. Art |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove time portion from date on Excel 2007 chart | Charts and Charting in Excel | |||
| Determine year over year date for comparison | Excel Worksheet Functions | |||
| How do I add a portion of a day to a date? | Excel Worksheet Functions | |||
| Matching the month and year portion of a date only | Excel Discussion (Misc queries) | |||
| Buttons in lower portion of workbook appear in upper portion | Excel Programming | |||
Hybrid Mode
