Help With a date formula

[RKAMAN]

I am relatively new to Exel and new to the forum.

I need a formula that will take 2 dates multiply the duration by 2, an
if the duration between the dates (multiplied by two) exceeds 90 days
then the number should be 90.

The dates represent the duration of time that an employee is unable t
work due to illness/injury. they get double that time to recover.

ex.
22 jun 04 to 27 jun 04 which is six days. they get an additional 6 day
for a total of 12.

if there is a situation where the duration of time betwee
dates(doubled) exceeds 90 days, they get a maximum of 90 days o
recovery (which occurs only when the "injury" time multiplied by tw
exceeds 90)


Thanks ahead of time

 

[Frank Kabel]

Hi
if the dates are in cells A1 and A2 try:
=MIN((A2-A1+1)*2,90)

 

[Jazzer]

Hi RKAMAN,

Let the starting day be in A1 and the ending day in B1 then you can us
a formula like this:

=MIN(2*(B1-A1),90)

If the first argument is greater that 90, then the MIN-function return
the second arg. 90 that is the smaller of the two args.

- Asse