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

MS Excel Date ranges

  • 21-11-2012 12:01pm
    #1
    trg
    Registered Users, Registered Users 2 Posts: 380 ✭✭


    Hi folks,

    Am stuck with a problem in excel 2010 i was hoping someone may be able to help me with.

    Say I've got a range of dates Jan/Feb/Mar/Apr/May

    and an event that started in Feb and finished in Apr

    I want to have a table what will calculate 1 for Feb/Mar/Apr to show the event was live during those months but 0 for Jan and May.

    I've tried if functions and if functions within if functions (not too hot at those) but cant get it.

    Below i set out teh raw data and below that the desired result, can anyone help?

    Start End
    Event 1 Feb 12 Apr 12
    Event 2 Jan 12 Mar 12

    Jan-12 Feb-12 Mar-12 Apr-12 May-12
    Event 1 0 1 1 1 0
    Event 2 1 1 1 0 0

    Thanks
    TRG


Comments

  • #2
    trg
    Registered Users, Registered Users 2 Posts: 380 ✭✭trg


    Sorry i see now that the result table didnt come publish as i typed it in, hope it makes sense!


  • #3
    PrzemoF
    Registered Users, Registered Users 2 Posts: 1,931 ✭✭✭PrzemoF


    Something like this?


  • #4
    trg
    Registered Users, Registered Users 2 Posts: 380 ✭✭trg


    Just about, thanks a million, really appreciate it.

    If adapted a little to get the digits in


Advertisement