Results 1 to 14 of 14

Formula to insert multiple dates

Threaded View

  1. 05-21-2021, 04:02 AM #1
    rayted
    rayted is offline
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    833

    Formula to insert multiple dates

    Hi all,

    I have a cell in I2 which has a date: 22/05/2021

    How can I write a formula to return the date for the next Monday, Wednesday anD fRIDAY?

    Basically I want the formula to change automatically with the date of the next Monday appearing first, after which the date for the next Wednesday and then the Friday's date., Is this possible?

    Thank you
    Attached Files Attached Files
    Thanks,

    R.


    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. Macro to insert copy of row if Open dates are less than Closed dates - delete rows in betw
    By bongielondy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-29-2019, 04:58 AM
  2. formula to insert certain numbers and dates
    By c_spooner1999 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-31-2015, 03:15 PM
  3. [SOLVED] Calendar Macro to insert multiple dates within the same cell
    By clprdctn in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-07-2014, 03:52 PM
  4. Formula to highlight dates on a calendar for multiple people scheduled for school dates
    By meltyface81 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2014, 02:01 AM
  5. [SOLVED] Macro that can grab dates within a parameterized list and insert rows with those dates
    By UMBiii in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-12-2014, 09:14 AM
  6. Formula to calculate interest earned on an investment and formula to auto insert dates
    By jmord888 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-02-2013, 02:28 PM
  7. Macro to Insert multiple rows at same location multiple sheets and copying down formula
    By nwjones in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2012, 01:07 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1