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!

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!