Results 1 to 5 of 5

Calculate number of occurences with last 3 and 6 months

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 occurences with last 3 and 6 months

    Hi,

    I have a row containing:

    Date entered
    Name
    Date of Birth (DOB)
    Occurrences of Name + DOB this Month
    Occurrences of Name + DOB within last 3 Months
    Occurrences of Name + DOB within last 6 Months

    I can manage the occurrences this month but haven't a clue how to calculate the 3 and 6 months ones. I have attached a sheet and would appreciate some guidance and help.

    Thank you in advance.
    Attached Files Attached Files
    Last edited by jpruffle; 07-14-2009 at 03:59 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