Results 1 to 10 of 10

Return value to a weekday closest to certain date

Threaded View

  1. 07-10-2018, 09:01 AM #4
    Ashleytaylor1702
    Ashleytaylor1702 is offline
    Registered User
    Join Date
    07-10-2018
    Location
    Uk
    MS-Off Ver
    MS365 Version 2102
    Posts
    86

    Re: Return value to a weekday closest to certain date

    Sorry about my first post please see the attached file.

    Basically I would like a formula that I could put in D1 then auto fill down to the bottom of the date range.

    I need the formula to pick up cell a6 IF it’s the 28th AND also if the 28th falls on a weekend then move the cell to the Friday prior to the weekend?

    Many thanks for any help
    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. [SOLVED] Formula to get weekday closest to 20th of the month
    By rizmomin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-20-2018, 06:32 PM
  2. How do I return ONLY the name of a weekday, from a cell/cells containing that day's date,
    By Dagswe21 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 11-02-2016, 09:54 AM
  3. Excel VBA code to return weekday name from a date then autofilters for userdefined weekday
    By studyengineering in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2016, 03:24 PM
  4. [SOLVED] Calculate weekday end date based on sum of weekday start date and cell value
    By Rerock in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2014, 09:17 AM
  5. Return value based on closest time/date and name
    By Steven87 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-11-2013, 03:52 PM
  6. Return date for the next coming weekday
    By ElmerS in forum Excel General
    Replies: 7
    Last Post: 05-24-2010, 12:51 PM
  7. Add a number to date and return a weekday
    By dwain in forum Excel General
    Replies: 3
    Last Post: 10-13-2008, 10:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1