LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 806
Default Sorting by Date when some dates span over several days

Hello Sarah,

I suggest to use Excel standard data types: Take two cells for a date
range and put in start date and end date, for example.

You avoid major hickups with data input, processing and output.

Even if you are forced to finally show the data as you described it
then you only need to deal with the output side...

Regards,
Bernd

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Conditional Formatting Dates calculating 10 days and 30 days from a certain date Sioux[_2_] Excel Worksheet Functions 2 October 11th 07 02:04 PM
TWO DATES,150 DAYS APART,NEED ONE DATE TO TURN RED AFTER 150 DAYS 440 Excel Programming 3 September 22nd 06 05:24 PM
Inconsistent excel 2007b2 time calculations that span whole days Alex Thomas Excel Discussion (Misc queries) 2 September 20th 06 03:51 AM
Dividing a time span into shifts - overlapping days Heidi Excel Worksheet Functions 17 February 28th 06 01:40 AM
Sorting Dates in Days of the Week Eagle784 Excel Discussion (Misc queries) 3 August 19th 05 05:31 PM


All times are GMT +1. The time now is 03:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"