Results 1 to 6 of 6

Count specific dates in cell range for current month

Threaded View

  1. #1
    Registered User
    Join Date
    05-21-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Cool Count specific dates in cell range for current month

    Hi all
    I have failed to build a working formula for 2003, I have a spread sheet and in column E3:E99 I have entered dates (Appointments)-- on a separate summery sheet I would like to see how many appointments I have scheduled for the current month. I am looking to tie the "valid" count criteria to my computer clock (RTC). In other words I only want to only count the appointments I have in the current month when I open the spreadsheet. My current formatted date is MM/DD/YY. I do not want to count any dates in the selected cells unless they are in the current month and year. Or at least the current month. I am in real need of a sanity check.
    The closest I have gotten to a working formula is
    =SUMPRODUCT(MONTH(E3:E99=MONTH(NOW())) (This is obviously not correct)
    Last edited by rboggio1; 05-21-2009 at 09:37 PM. Reason: Failed to comply with terms

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