Posted to microsoft.public.excel.programming

smitty24

external usenet poster

Posts: 3

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
working with dates	Jordan	Excel Worksheet Functions	2	December 3rd 07 07:43 PM
Working with dates	Harley	Excel Discussion (Misc queries)	3	September 5th 07 08:07 AM
working with dates	Svetlana	Excel Worksheet Functions	2	October 3rd 06 04:59 PM
Working with dates	Al	Excel Worksheet Functions	3	April 21st 06 05:49 PM
working with dates	Phil kelly	Excel Discussion (Misc queries)	2	June 21st 05 12:05 PM

All times are GMT +1. The time now is 02:52 PM.

About Us

"It's about Microsoft Excel"