calculate the date from ceased work date after a certain waiting p

[brenda]

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

 

[Jacob Skaria]

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

 

[OssieMac]

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.