Results 1 to 10 of 10

Excel 2007 : Count number of cells less than or equal to today's date

Threaded View

  1. #1
    Registered User
    Join Date
    08-24-2011
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2003
    Posts
    17

    Count number of cells less than or equal to today's date

    Someone please help
    I am close to a nervous breakdown.

    Can you tell me in SIMPLE terms how I can do the following... I have in coulm B a long list of dates in the format of dd/mm/yyy and in colum a i have todays date (set automatically by the =Now() formula) , I want to count the number of cells in column B that are less than or equal to this specfic date however each time I do it comes back errors or doesnt calculate it correctly. I have tried the countif formula but can't get it to work. I have amnually counted the lines as a control and each time the figure I get back is wrong.... Please help me!!!!!

    Last edited by marthadanielle; 08-25-2011 at 03:40 AM.

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