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

B

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
 
J

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
 
O

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.
 
Top