Results 1 to 7 of 7

Calculate number of dates within a column based on Month

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-03-2008
    MS-Off Ver
    Excel 2007 (also have access to Excel 2000/2003)
    Posts
    368

    Calculate number of dates within a column based on Month

    Hi,

    I have a column say column B for example that has a list of dates in the format dd/mm/yyyy. I would like a summary at the top of the columns to state how many dates there are for the current month. But I wondered if this was possible based on the TODAY() function or similar. Thus the user would not have to change anything.

    So for example at the start of the month it may state 14. Half way through the month down to 6 and at the end of the month 0 for example.

    Also is this possible with the month ahead based on the same principle?

    Thanks.
    Last edited by jpruffle; 05-15-2009 at 12:40 PM.

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