Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-13-2011, 10:38 AM
newton.rogers newton.rogers is offline lookup dates and return corresponding data Windows XP lookup dates and return corresponding data Office 2003
Novice
lookup dates and return corresponding data
 
Join Date: Aug 2011
Location: Newcastle
Posts: 6
newton.rogers is on a distinguished road
Post lookup dates and return data

Please find a copy of the spreadsheet attached, the cells H2 to J9 is the result of populating cells E2 and F2. Hope you gather the layout, columns D and G are only for spacing.

A B C D E F G H I J 1 In Date Out Date NetWorkdays Start Date End Date In Date Out Date NetWorkdays 2 15/08/2011 18/08/2011 4 15/08/2011 28/08/2011 15/08/2011 18/08/2011 4 3 15/08/2011 22/08/2011 6 15/08/2011 22/08/2011 6 4 19/08/2011 29/08/2011 7 19/08/2011 29/08/2011 7 5 20/08/2011 25/08/2011 4 20/08/2011 25/08/2011 4 6 23/08/2011 01/09/2011 8 23/08/2011 01/09/2011 8 7 24/08/2011 27/08/2011 3 24/08/2011 27/08/2011 3 8 27/08/2011 05/09/2011 6 27/08/2011 05/09/2011 6 9 28/08/2011 02/09/2011 5 28/08/2011 02/09/2011 5 10 31/08/2011 04/09/2011 3 11 31/08/2011 06/09/2011 5
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup dates and return corresponding data LookUp aztiguen24 Excel 5 05-24-2011 03:57 AM
Multi-Variable Lookup help ebolton Excel 8 05-05-2011 05:28 AM
lookup dates and return corresponding data Lookup a value from non-sorted data udea Excel 12 04-25-2011 04:34 AM
lookup dates and return corresponding data Using the LOOKUP Command Grapejuice Excel 2 10-15-2008 02:02 PM
Help with Max or lookup fomula to return a name forAmaxValue dutch4fire23 Excel 0 07-28-2006 01:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft