Require a Formula to caluclate the date

[Raj]

HI

My data distribution is as follows. generaly we raise tickets and for each
and every Ticket as a category say category 1, Category 2 and category 3.
My requirement is category 1 ticket must be solved in 1 working day and 2 in
3 working days.

Every ticket has a date of request raised.
The data is distributed as followa

Ticket No Category rquested date
1111 1 4-apr-2009

So the above ticket must be resolved in requested date + 1 working day.

I want to display a date in column D the ticket to be resolved date on the
above formula. But it should not calculate the Saturday and Sunday.

So the resolved date must be 7-Apr-2009

Can any one help me regarding this. Its very urgent.

Raj

 

[Roger Govier]

Hi Raj

Provide you have the add in Tools>Addins>Analysis Toolpak, then in D2
=WORKDAY(C2,B2)
will give your result. Format the cell as Date

You can also add the 3rd optional argument, and give a range of days that
are holidays, so that they get excluded in the calculation as well.
With a list of holidays in say X1:X15, then
=WORKDAY(C2,B2,X1:X15)