Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel - Set target dates, overdue date

  • 12-03-2012 3:24pm
    #1
    Drumpot
    Registered Users, Registered Users 2 Posts: 19,306 ✭✭✭✭


    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.


Comments

  • #2
    rockal
    Registered Users, Registered Users 2 Posts: 757 ✭✭✭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)


Advertisement