searching dates in excel!!!

Discussion in 'Microsoft Office Specialist (MOS), Office 365' started by Chopperchand, Apr 29, 2008.

  1. Chopperchand

    Chopperchand Nibble Poster

    75
    0
    16
    Hi All,

    I had a request from a user at work, She's got a spreadsheet and would like to do the following

    "I want to calculate the number of entries between two dates so we can
    work out statistics by month"


    Basically what she wants is to enter two dates say

    01/01/08
    to
    28/02/08

    And excel to return the number of entries between those dates

    eg

    01/01/08 - food1
    05/02/08 - food2
    31/03/08 - food3
    24/02/08 - food4

    With the criteria above it would return "3"

    I could use countif but don't know how to search between dates

    Any idea's / help would be gratefully accepted

    Thanks
     
    WIP: MCSA Sql Server 2012
  2. BosonMichael
    Honorary Member Highly Decorated Member Award 500 Likes Award

    BosonMichael Yottabyte Poster

    19,183
    500
    414
    =COUNTIF(A1:A4,">=1/1/2008")-COUNTIF(A1:A4,">28/2/2008")

    Replace the range A1:A4 with the range you want.
     
    Certifications: CISSP, MCSE+I, MCSE: Security, MCSE: Messaging, MCDST, MCDBA, MCTS, OCP, CCNP, CCDP, CCNA Security, CCNA Voice, CNE, SCSA, Security+, Linux+, Server+, Network+, A+
    WIP: Just about everything!
  3. Chopperchand

    Chopperchand Nibble Poster

    75
    0
    16
    Thanks BosonMichael,

    Worked a treat!!

    You're a star!!!! (what user said to me!!!, so fitting I pass on the compliment to the reason solver)!!! lol:D
     
    WIP: MCSA Sql Server 2012
  4. BosonMichael
    Honorary Member Highly Decorated Member Award 500 Likes Award

    BosonMichael Yottabyte Poster

    19,183
    500
    414
    My pleasure - always here to help. :)
     
    Certifications: CISSP, MCSE+I, MCSE: Security, MCSE: Messaging, MCDST, MCDBA, MCTS, OCP, CCNP, CCDP, CCNA Security, CCNA Voice, CNE, SCSA, Security+, Linux+, Server+, Network+, A+
    WIP: Just about everything!
  5. Sparky
    Highly Decorated Member Award 500 Likes Award

    Sparky Zettabyte Poster Moderator

    10,718
    543
    364
    You do realise that the user will contact you for every Excel problem now. Do you have BMs email address? :biggrin
     
    Certifications: MSc MCSE MCSA:M MCSA:S MCITP:EA MCTS(x5) MS-900 AZ-900 Security+ Network+ A+
    WIP: Microsoft Certs
  6. BosonMichael
    Honorary Member Highly Decorated Member Award 500 Likes Award

    BosonMichael Yottabyte Poster

    19,183
    500
    414
    I hope so; I have an attractive hourly rate, with a one-hour minimum charge. ;) heehee!

    just kidding. :)
     
    Certifications: CISSP, MCSE+I, MCSE: Security, MCSE: Messaging, MCDST, MCDBA, MCTS, OCP, CCNP, CCDP, CCNA Security, CCNA Voice, CNE, SCSA, Security+, Linux+, Server+, Network+, A+
    WIP: Just about everything!
  7. Chopperchand

    Chopperchand Nibble Poster

    75
    0
    16

    You must be a fortune teller Sparky, :) I had 4 more function requests from the same user. lucky knew the answer!!

    Could never afford BosonMichael's fee's LOL!!!:)
     
    WIP: MCSA Sql Server 2012

Share This Page

Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.