Calculate date 28 days from now if hours reduce
 

In a spreadsheet to calculate changes in an employee's hours, cell A5
holds the old hours worked, B5 holds the new hours, and C5 calculates
the difference between A5 and B5. A7 holds the date that the change is
effective.

B7 shows the date on which the variation to the contract is effective.
This is where I need assistance.

If the hours have increased, then B7 should have the same value as A7
(because with an increase in hours the change is effective
immediately).

If however the hours have reduced, then B7 needs to show an "effective
from" date 28 days after the date in A7 (because with a reduction, a
member of staff needs to be given 28 days notice).

A7 and B7 are both formatted to display dates using the the format
DD/MM/YY.

Can anyone suggest a way of doing this?

Thanks

Calculate date 28 days from now if hours reduce
 

In B7

=A7+(B5<A5)*28

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"watty" wrote in message
ups.com...
In a spreadsheet to calculate changes in an employee's hours, cell A5
holds the old hours worked, B5 holds the new hours, and C5 calculates
the difference between A5 and B5. A7 holds the date that the change is
effective.

B7 shows the date on which the variation to the contract is effective.
This is where I need assistance.

If the hours have increased, then B7 should have the same value as A7
(because with an increase in hours the change is effective
immediately).

If however the hours have reduced, then B7 needs to show an "effective
from" date 28 days after the date in A7 (because with a reduction, a
member of staff needs to be given 28 days notice).

A7 and B7 are both formatted to display dates using the the format
DD/MM/YY.

Can anyone suggest a way of doing this?

Thanks

Calculate date 28 days from now if hours reduce
 

Many thanks - that works fine!


Bob Phillips wrote:
In B7

=A7+(B5<A5)*28

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"watty" wrote in message
ups.com...
In a spreadsheet to calculate changes in an employee's hours, cell A5
holds the old hours worked, B5 holds the new hours, and C5 calculates
the difference between A5 and B5. A7 holds the date that the change is
effective.

B7 shows the date on which the variation to the contract is effective.
This is where I need assistance.

If the hours have increased, then B7 should have the same value as A7
(because with an increase in hours the change is effective
immediately).

If however the hours have reduced, then B7 needs to show an "effective
from" date 28 days after the date in A7 (because with a reduction, a
member of staff needs to be given 28 days notice).

A7 and B7 are both formatted to display dates using the the format
DD/MM/YY.

Can anyone suggest a way of doing this?

Thanks