LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sbufkle
 
Posts: n/a
Default Problem with Date Manipulation


Okay.. Im not a kid, 36, been working with excel for years & last year
did up to intermediate courses in Access.

However, that being said because you guys are very keen in here, so I
dont want to sound stupid, whilst my understanding on alot of excel is
generally on the layman terms!

Heres my problem.

Im making a simple spreadsheet.

I have a widget that enters my facility on one date, it then exits
another. I know by setting up EXIT - ENTER = DAYS I have my duration in
the facility.

BUT--- I dont want the weekends to count as days!

Material arrives every weekday & exits the same. Some material flows
every day.. some rarely with EVERYTHING in between.

Any suggestions/solutions how to have this accomplished where the
weekends are factored OUT of the equasion?

Hope that made sence!!!

I do appreciate your help!


--
Sbufkle
------------------------------------------------------------------------
Sbufkle's Profile: http://www.excelforum.com/member.php...o&userid=29069
View this thread: http://www.excelforum.com/showthread...hreadid=487950

 
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
Date Formatting Problem Jocko69 Excel Discussion (Misc queries) 3 November 6th 05 06:59 PM
Date sorting problem Ardell Excel Discussion (Misc queries) 1 November 4th 05 05:46 PM
Time Date Formula Problem Oowf Excel Worksheet Functions 2 June 1st 05 06:01 PM
Login Logout Date Problem ascool_asice Excel Worksheet Functions 2 May 30th 05 12:50 AM
Date and Time Picker Control problem Andy Tallent Excel Discussion (Misc queries) 0 May 4th 05 12:50 PM


All times are GMT +1. The time now is 10:04 AM.

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

About Us

"It's about Microsoft Excel"