+ Reply to Thread
Results 1 to 9 of 9

Count dates in a column -24hrs

  1. #1
    Registered User
    Join Date
    10-15-2008
    Location
    Lincolnshire
    Posts
    53

    Count dates in a column -24hrs

    I have a range of data in a spreadsheet that has entry dates. To one side I have a cell that =today()
    What I want to do is where the entry date is in my range of data is insert a column that will tell me "yes" if the entry date =today()-1

    I have tried different ways to achieve this but no success.

    Please help
    Last edited by famico78; 11-24-2009 at 10:35 AM.

  2. #2
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949

    Re: Count dates in a column -24hrs

    If you could provide a sample workbook it would help a lot.
    insert a column that will tell me "yes" if the entry date =today()-1
    You want to insert a new column, or you just want a column that displays "yes" ?
    =IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)

  3. #3
    Registered User
    Join Date
    10-15-2008
    Location
    Lincolnshire
    Posts
    53

    Re: Count dates in a column -24hrs

    Just to mention, the data is sent to the spreadsheet from access and the date shows as 18-Nov-09 but the cell when highlighted shows 18/11/2009 11:41:32

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Count dates in a column -24hrs

    Write this if you want only 17.11.2009 to be showed as yes

    =IF($G$1-F2=1;"yes";"no")

    or

    =IF($G$1-F21>=1;"yes";"no") for all smaller than today

  5. #5
    Registered User
    Join Date
    10-15-2008
    Location
    Lincolnshire
    Posts
    53

    Re: Count dates in a column -24hrs

    Just want a column that displays "yes"

  6. #6
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Count dates in a column -24hrs

    Quote Originally Posted by famico78 View Post
    Just to mention, the data is sent to the spreadsheet from access and the date shows as 18-Nov-09 but the cell when highlighted shows 18/11/2009 11:41:32
    there is difference between TODAY() and NOW() function.

    First is for date only. Second is for date and hour.

  7. #7
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Count dates in a column -24hrs

    Hi

    If entry date is in A1 in A2 enter =if(int(A1)=today()-1,"yes","")

  8. #8
    Registered User
    Join Date
    10-15-2008
    Location
    Lincolnshire
    Posts
    53

    Re: Count dates in a column -24hrs

    Quote Originally Posted by arthurbr View Post
    Hi

    If entry date is in A1 in A2 enter =if(int(A1)=today()-1,"yes","")
    This worked perfectly, thanks

  9. #9
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Count dates in a column -24hrs

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1