Results 1 to 5 of 5

Dateinterval - return weeks inbetween

Threaded View

  1. #1
    Registered User
    Join Date
    11-25-2016
    Location
    Aalborg, Denmark
    MS-Off Ver
    MS Office Pro Plus 2013
    Posts
    7

    Dateinterval - return weeks inbetween

    Hi,

    I am presented with data for qoutes for rental systems. The data has a start date and an end date. I would like the data to give me the weeknumbers inbetween so that I can create a total pipeline for all quotes pr. week. Any suggestions? See attached.

    Br Andy
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Add 12 weeks to date to return week number turn over at 52 weeks
    By nigelog in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-01-2017, 05:58 AM
  2. Delete every date out of an dateinterval
    By KasperDK in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2016, 08:25 AM
  3. [SOLVED] Lookup/Index/Match to Return Value of Higher number rather than lower# when inbetween
    By ReedDOT in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-16-2013, 11:56 PM
  4. [SOLVED] Return value when word begins inbetween two letters
    By se15 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-14-2013, 08:12 AM
  5. How to return totals with dates between 52 weeks?
    By chanpink in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-01-2013, 10:08 AM
  6. [SOLVED] Return Max of Sum of 4 weeks data in a row
    By ABSTRAKTUS in forum Excel General
    Replies: 6
    Last Post: 04-14-2012, 01:03 PM
  7. return calculation every four weeks
    By webwolf_3000@msn.com in forum Excel General
    Replies: 1
    Last Post: 05-11-2006, 07:20 AM

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