Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Excel: counting the number of dates in a column

  • 03-09-2018 04:37PM
    #1
    Calahonda52
    Registered Users, Registered Users 2 Posts: 12,998 ✭✭✭✭


    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

  • #2
    namenotavailablE
    Registered Users, Registered Users 2 Posts: 59,793 ✭✭✭✭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



  • #3
    Calahonda52
    Registered Users, Registered Users 2 Posts: 12,998 ✭✭✭✭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”.



  • #4
    L'prof
    Registered Users, Registered Users 2 Posts: 12,054 ✭✭✭✭L'prof


    counta(A:A)


  • #5
    Calahonda52
    Registered Users, Registered Users 2 Posts: 12,998 ✭✭✭✭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