| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with dates
If a cell has a date in it formatted either mm/dd/yyyy or m/d/yyyy how can I
identify the year (yyyy) and copy the year only to a new cell? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Working with dates
One way:
In the new cell: =YEAR(A1) In article , smitty24 wrote: If a cell has a date in it formatted either mm/dd/yyyy or m/d/yyyy how can I identify the year (yyyy) and copy the year only to a new cell? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| working with dates | Excel Worksheet Functions | |||
| Working with dates | Excel Discussion (Misc queries) | |||
| working with dates | Excel Worksheet Functions | |||
| Working with dates | Excel Worksheet Functions | |||
| working with dates | Excel Discussion (Misc queries) | |||
Linear Mode
