Results 1 to 3 of 3

Extend current formula for a date range

Threaded View

  1. #2
    Valued Forum Contributor
    Join Date
    09-01-2013
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    324

    Re: Extend current formula for a date range

    Well after piecing together internet codes I think I've put together the below code. If anyone see's any issues with it please let me know but i'm still trying to incorporate it to use the Boolean YES/NO to determine if the first week of the month should be counted as week one or if the 4 weeks after the is 4 weeks should be counted.

    =IF(INT((DAY(C6)-1)/7)+1=1,COUNTIFS(G:G,I12),"0")
    Last edited by playaller; 10-08-2013 at 09:42 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Need average of days for date values from date to current day that updates current date
    By FinGhost in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-12-2013, 04:41 PM
  2. [SOLVED] Selecting data from a date range based on the current date
    By ian-sheridan in forum Excel General
    Replies: 12
    Last Post: 06-20-2013, 11:38 AM
  3. Formula that will pull by a date range of the current date
    By terra_hewitt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-04-2012, 11:08 AM
  4. generating date range from current date
    By dexelguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2008, 04:52 PM
  5. [SOLVED] How do I enter a date range ie -7 from current date in MS QUERY
    By notsmartenough in forum Excel General
    Replies: 1
    Last Post: 11-11-2005, 06:25 PM

Tags for this Thread

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