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

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

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