Posted to microsoft.public.excel.misc

Grey Old Man[_2_] Grey Old Man[_2_] is offline

external usenet poster

Posts: 24

Unusual Date Format

I am writing an Excel 2002 template. I am importing two columns of dates
(date from and date to) from an external source. The date format is 'cyymmdd'
so today would be '1100421'. The cells are formatted as text.

I need to calculate the difference between the two dates, shown as a number
of weeks rounded down to the nearest whole number.

Any help would be appreciated.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
permanent conversion of 1904 date format to 1900 date format	Jos	Excel Worksheet Functions	4	November 26th 15 02:48 PM
Unusual Date Format	Grey Old Man[_2_]	Excel Discussion (Misc queries)	1	April 21st 10 08:52 AM
Display the date in an unusual format	Barry	Excel Discussion (Misc queries)	0	March 31st 10 03:46 AM
convert serial date format to normal date format	Flagworld	Excel Discussion (Misc queries)	3	September 23rd 08 01:32 PM
Unusual data format	Salty	Excel Worksheet Functions	2	November 3rd 05 12:40 PM

All times are GMT +1. The time now is 07:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us