Results 1 to 6 of 6

Find closest week ending date to any date

Threaded View

  1. 10-25-2019, 05:39 AM #1
    jmont
    jmont is offline
    Registered User
    Join Date
    09-25-2019
    Location
    northern ireland
    MS-Off Ver
    2010
    Posts
    19

    Find closest week ending date to any date

    HI

    I have a column of date data (transaction dates - not in order) and week ending dates (always a friday)

    I would like to find the closest Friday to each transaction date

    Any suggestions would be greatly appreciated

    Thanks
    Jonny
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculation of Week Number & Week Ending Date formula from a Year Cell
    By Neilesh Kumar in forum Excel General
    Replies: 5
    Last Post: 04-11-2017, 09:23 AM
  2. [SOLVED] Find the Week Ending Date
    By trosasco in forum Excel General
    Replies: 5
    Last Post: 02-06-2014, 11:20 AM
  3. Sheets for every week + start and ending date of the week
    By wimexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-30-2012, 01:48 PM
  4. Convert date range to week ending date
    By minkus in forum Excel General
    Replies: 5
    Last Post: 11-29-2010, 04:30 PM
  5. Week ending date help
    By PRodgers4284 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-12-2009, 05:07 AM
  6. Formula to find week-ending date?
    By chave982 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-17-2008, 10:48 AM
  7. week ending date?
    By SRussell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-11-2008, 06:42 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1