Excel - Set target dates, overdue date

Drumpot

Hi,

Using this for work and while what I have is ok, I wouldnt mind refining it if possible (and easy!). Any tips would be greatly appreciated.

I used the following calc:

=$E2+5-TODAY()

E2 = date at which I input data
F grid = "Days Due" column

In this instance I give myself 5 days to complete the information.

Is there anyway of doing this equation to make these only workdays? I understand I can just make it 7 days, but on a friday it could be easy to forget that you only have 1 day if something is due on a monday (would say 3 days left).

Also, is it possible to have something on the lines of "5 days left" or "overdue" once its passed the deadline ?

Lastly, is it possible to have dropdown options on the F grid (Days due) so that I could choose differant options (ie 5, 10, 14 days etc).

Any tips would be greatly appreciated.

rockal

Use this =NETWORKDAYS($E2+5,TODAY())

Have you considered Holidays?
If so create a column of Holiday dates (example G2 to G25)
Then use =NETWORKDAYS($E2+5,TODAY(),G2:G25)