+ Reply to Thread
Results 1 to 4 of 4

Pulling data from +today() cell

  1. #1
    Registered User
    Join Date
    10-15-2009
    Location
    Winnipeg
    MS-Off Ver
    Excel 2007
    Posts
    7

    Pulling data from +today() cell

    I am using the function TODAY(). The date is in a custom format of YYYYMMDD. How can I take this date and use it as it appears without converting it to Julien format?

  2. #2
    Forum Contributor Mvaldesi's Avatar
    Join Date
    01-21-2011
    Location
    Plano, TX
    MS-Off Ver
    Excel 2016
    Posts
    231

    Re: Pulling data from +today() cell

    Are you completely averse to using a helper column to convert your custom format to a standard one then calculating off of that? You could always hide the helper column afterwards so your custom format would be the only visible one.

  3. #3
    Registered User
    Join Date
    10-15-2009
    Location
    Winnipeg
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Pulling data from +today() cell

    No. That would be fine. I just need to be able to take the format provided for today() and use if for pulling cells from other worksheets so a helper cell could do the trick. What would the steps be?

  4. #4
    Forum Contributor Mvaldesi's Avatar
    Join Date
    01-21-2011
    Location
    Plano, TX
    MS-Off Ver
    Excel 2016
    Posts
    231

    Re: Pulling data from +today() cell

    Not sure I'm understanding exactly what you mean, but take a look at the attached file. I'm converting dates (including "=TODAY()) too and from your custom format, the idea being you can use that converted value in your calculations.

    Your custom format to standard date =TEXT(A3,"0000-00-00")
    Standard format to your custom format =TEXT(A2,"yyyymmdd")
    Attached Files Attached Files

+ 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. Replies: 1
    Last Post: 05-25-2018, 04:12 PM
  2. [SOLVED] Pulling data from a cell.
    By L0st in forum Excel General
    Replies: 14
    Last Post: 08-03-2015, 12:38 PM
  3. [SOLVED] Copying today's date into cell when multiple data is entered into adjacent cell
    By SChapman in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-16-2013, 04:12 PM
  4. Pulling a Specific Cell when Pulling a Tabel from Web Based Data
    By Zallen89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2013, 05:39 PM
  5. Replies: 2
    Last Post: 02-27-2009, 02:01 PM
  6. [SOLVED] Pulling some data from cell?
    By tr2usa@yahoo.com in forum Excel General
    Replies: 7
    Last Post: 01-03-2006, 05:45 PM
  7. pulling certain data out of a cell
    By D richardson in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-13-2005, 02:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1