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

Excel: counting the number of dates in a column

Options
  • 03-09-2018 5:37pm
    #1
    Calahonda52
    Registered Users Posts: 12,386 ✭✭✭✭


    I need to insert the date of my monthly meetings in a spreadsheet, and I then need to count the number of meetings and insert this value in another spread sheet.
    I can do it using 2 columns but would prefer one :)
    So
    my current spreadsheet looks like
    Date Counter
    23/11/2018 1
    24/11/2018 1

    I have tried CountIf but no joy
    =CountIF(a1: a10,"*")
    and
    =CountIF(A1:A10, "??????2018"
    Thanks as always

    “I can’t pay my staff or mortgage with instagram likes”.



Comments

  • Options
    #2
    namenotavailablE
    Registered Users Posts: 59,602 ✭✭✭✭namenotavailablE


    Maybe something like this copied down (I suspect there's a way simpler method):

    =IF(YEAR(A1)>=YEAR(NOW()),COUNTIF($A$1:A1,">0"),"")

    Free Excel net pay calculator- https://taxcalc.eu/monthlyss/Employee%20PAYE%20calculator.xlsm



  • Options
    #3
    Calahonda52
    Registered Users Posts: 12,386 ✭✭✭✭Calahonda52


    I just made text from the date by adding '23/11/2018 makes =CountIF(a1: a10,"*") work

    “I can’t pay my staff or mortgage with instagram likes”.



  • Options
    #4
    L'prof
    Registered Users Posts: 12,032 ✭✭✭✭L'prof


    counta(A:A)


  • Options
    #5
    Calahonda52
    Registered Users Posts: 12,386 ✭✭✭✭Calahonda52


    L'prof wrote: »
    counta(A:A)

    Thanks, this works with dates as normal dates :)

    “I can’t pay my staff or mortgage with instagram likes”.



Advertisement