+ Reply to Thread
Results 1 to 2 of 2

return the day from a date (Tuesday)

  1. #1
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    At Work its 2010 At Home 2019
    Posts
    418

    return the day from a date (Tuesday)

    hello All

    i enter an order date in A1 and A2 factorsd in the delivery time.... i want A2 To display the date with Tuesday ord wednesday what ever the day is


    A1 = 19/02/2019

    A2 = WORKDAY(A1,4,0) Returns 25/02/2019 i want it to return Tuesday 25th

    Paul

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,062

    Re: return the day from a date (Tuesday)

    Try this formula in A2: =TEXT(WORKDAY(A1,4,0)," ddddd d")&LOOKUP(DAY(WORKDAY(A1,4,0)),{1,2,3,4,21,22,23,24,31;"st","nd","rd","th","st","nd","rd","th","st"})
    Click the * to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Return the tuesday before the 20th of a month before an effective date
    By Alphabex in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-19-2018, 03:47 PM
  2. [SOLVED] date + 30 days, Tuesday following that
    By mlgarza19 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-11-2014, 12:24 AM
  3. [SOLVED] Get next Tuesday based on a date.
    By mattress58 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2014, 04:34 PM
  4. How to show only Working Day on expire date (Friday + 2 = Tuesday)
    By alexnkc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-20-2013, 01:01 PM
  5. Getting Days like Monday, Tuesday etc. from Date
    By rms10 in forum Excel General
    Replies: 2
    Last Post: 09-29-2008, 09:23 PM
  6. [SOLVED] How do/can I calculate the date for every Tuesday???
    By Jay in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-04-2006, 11:10 AM
  7. Replies: 5
    Last Post: 04-10-2005, 09:06 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