| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate the date from ceased work date after a certain waiting p
Hi,
I need help. I am trying to calculate the first payment of claims from the date ceased worked after waiting period of of 90 days. Any help will be appreciated. Regards, Brenda |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate the date from ceased work date after a certain waiting p
A1 = Date
If you are looking at working days B1 =WORKDAY(A1,90) You need to add the AddIn from menu Tools|Add-Ins (Analysis ToolPak VBA). If you are looking for the date after 90 days B1 = A1+90 (Format cells to date) If this post helps click Yes --------------- Jacob Skaria "brenda" wrote: Hi, I need help. I am trying to calculate the first payment of claims from the date ceased worked after waiting period of of 90 days. Any help will be appreciated. Regards, Brenda |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate the date from ceased work date after a certain waiting p
Hi Brenda,
If I understand your question correctly then you just have to add 90 to the date and a date 90 days ahead will be returned. -- Regards, OssieMac "brenda" wrote: Hi, I need help. I am trying to calculate the first payment of claims from the date ceased worked after waiting period of of 90 days. Any help will be appreciated. Regards, Brenda |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to calculate end date using order date and lead time variab | Excel Worksheet Functions | |||
| How do I calculate WORK-hours between end/start date | Excel Discussion (Misc queries) | |||
| Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| Waiting for "Calculating Cells" when there is little to calculate | Excel Discussion (Misc queries) | |||
Linear Mode
