+ Reply to Thread
Results 1 to 3 of 3

text date formula

  1. #1
    Registered User
    Join Date
    09-29-2020
    Location
    israel
    MS-Off Ver
    2017
    Posts
    2

    Question text date formula

    Hi, I need to make date range in a cell that depended on a date that in another cell.
    lets say that in A1 i have the date 29/9/2020, I want that in another cell to have the text: "28/9/2020 - 29/9/2020".

    P.s
    This is the format of date in my country

    Thanks

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,724

    Re: text date formula

    So you want the date range to go from the previous day to the date in A1?

    If so you can use this in B1:

    =TEXT(A1-1,"dd/m/yyyy") & " - " & TEXT(A1,"dd/m/yyyy")

    Hope this helps.
    Pete

  3. #3
    Registered User
    Join Date
    09-29-2020
    Location
    israel
    MS-Off Ver
    2017
    Posts
    2

    Re: text date formula

    Perfect, 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. Formula to find the earliest date in excel base on a given date and text
    By Rikii Sumat in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-27-2017, 02:35 AM
  2. [SOLVED] Formula to get date text format of date
    By rizmomin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-10-2016, 07:26 PM
  3. Formula showing a TEXT & date, in the next column i need to add 2 days on the date
    By JessSilvertail in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2016, 05:42 AM
  4. [SOLVED] Date format for two dates in a concatenated formula text included in the formula?
    By bkanealy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-12-2015, 04:33 PM
  5. Replies: 5
    Last Post: 09-24-2013, 02:40 PM
  6. Formula to convert text to a date in a date format
    By mikeburg in forum Excel General
    Replies: 5
    Last Post: 08-24-2011, 09:15 AM
  7. Replies: 1
    Last Post: 03-16-2011, 11:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1