Formula for changing date format

Posted to microsoft.public.excel.worksheet.functions

juamig

Posts: n/a

Formula for changing date format

Is there an easy way to change a date format from mm/dd/yy to yyyymmdd?

Also how would I perform the function of only coping over the year to a new
column once I have it in the yyyymmdd format?

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
Formula for determining if two date columns fall within specific date range	Igottabeme	Excel Worksheet Functions	2	April 21st 06 02:50 AM
Formula for determining if two date columns fall within specific date range	Igottabeme	Excel Discussion (Misc queries)	1	April 20th 06 10:03 PM
date format and the RIGHT function	Rich Hayes	Excel Worksheet Functions	2	December 19th 05 12:29 PM
date format and the RIGHT function	Rich Hayes	Excel Worksheet Functions	0	December 19th 05 11:06 AM
formula for filtering and a defaulting date	Sue	Excel Worksheet Functions	3	July 26th 05 02:18 PM

All times are GMT +1. The time now is 07:21 AM.

Menu

About Us