Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Formatting Problem | Excel Discussion (Misc queries) | |||
Date sorting problem | Excel Discussion (Misc queries) | |||
Time Date Formula Problem | Excel Worksheet Functions | |||
Login Logout Date Problem | Excel Worksheet Functions | |||
Date and Time Picker Control problem | Excel Discussion (Misc queries) |