Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
duration days | Excel Discussion (Misc queries) | |||
Calculating elapsed days and hours | Excel Discussion (Misc queries) | |||
How do I calculate the week day hours between 2 days | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
how to calculate a date .. say 34 days from today | Excel Discussion (Misc queries) |