Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need to subtract 2 different sets of dates to get a total amount of days.
Eg: (a-b)+(c-d) = e I then need to take the total (e) and multiply by 3 different integers if the total (e) is greater than 6 days,10 days and 31days. This helps me keep track how long my company trucks are out of a Rail/Ship Yard. I can't seem to get the dates to subtract and get an integer(regular number). and I'm dead lost on the greater than stuff. Of course the boss drops this on me on my first day. Any help or comments will come highly appreciated. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |