1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

searching dates in excel!!!

Discussion in 'Microsoft Office Specialist (MOS)' 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
    Highly Decorated Member Award

    BosonMichael Yottabyte Poster

    19,136
    462
    374
    =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
    Highly Decorated Member Award

    BosonMichael Yottabyte Poster

    19,136
    462
    374
    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

    Sparky Zettabyte Poster Moderator

    10,191
    296
    319
    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) Security+ Network+ A+
    WIP: Exchange 2007\2010
  6. BosonMichael
    Highly Decorated Member Award

    BosonMichael Yottabyte Poster

    19,136
    462
    374
    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...