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

Quick Excel question

  • 02-09-2010 8:05am
    #1
    scottyboy1973
    Registered Users, Registered Users 2 Posts: 184 ✭✭


    Hey there

    I'm being outfoxed by a formula in excel - I know there are loads of excel junkies out there so if one of you has any ideas I'd be grateful. :-)

    I'm planning a project and I have an end-date (of say 1 September)

    There are a number of activities that have to take place before then, all of which are a specific number of days before the end-date.

    I could just do =sum([end date cell]-10) to display a deadline 10 days before the end date but, of course, that assumes a 7 day week - we only work 5 days and that's the bit that's foxing me!

    I thought the NETWORKDAYS formula might work but I couldn't get it going?

    Any thoughts or creative ideas are most welcome! :-)

    thanks a million - S


Comments

  • #2
    rockal
    Registered Users, Registered Users 2 Posts: 757 ✭✭✭rockal


    Try using WORKDAY instead.


Advertisement