Bryan J Bloom Wrote:
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

Hi Bryan

To subtract your dates try this in E1 =((A1-B1)+(C1-D1)), format the
cell as general

For the other stuff try this
=IF(E1<6,"",IF(AND(E1=6,E1<=10),E1*1,IF(AND(E110 ,E1<=31),E1*2,E1*3)))

change the *1, *2, & *3 to be the 3 integers you want to use


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=480577