Results 1 to 10 of 10

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

Threaded View

marthadanielle Count number of cells less... 08-24-2011, 10:58 AM
romperstomper Re: Please help me!!... 08-24-2011, 11:12 AM
marthadanielle Re: Please help me!!... 08-24-2011, 11:16 AM
NBVC Re: Count number of cells... 08-24-2011, 11:48 AM
marthadanielle Re: Count number of cells... 08-24-2011, 11:57 AM
NBVC Re: Count number of cells... 08-24-2011, 12:03 PM
romperstomper Re: Count number of cells... 08-24-2011, 12:03 PM
marthadanielle Re: Count number of cells... 08-25-2011, 03:38 AM
zlpalmer Re: Excel 2010 : Count number... 01-10-2013, 08:07 PM
zlpalmer Re: Excel 2007 : Count number... 01-10-2013, 08:13 PM
  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