Results 1 to 4 of 4

Thread: Formula reference cell

  1. #1
    Acolyte chrisl614's Avatar
    Join Date
    Apr 2019
    Posts
    27
    Articles
    0
    Excel Version
    2016

    Formula reference cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi.
    I have a workbook, and everyday I track daily changes in about 20 different categories. Everyday I duplicate the current worksheet and name it whatever todays date is example 10-28-21.
    Instead of changing the formula in each of the 20 cells (I just change it in one and drag down, but...) would I be able to have a field with a date so anytime I put the name of the sheet I want it reference the formula will know to look at that sheet.

    I'm attaching an excel file showing this a little better. Thanks in advance.
    Attached Files Attached Files

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,726
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    You could try this:

    =INDIRECT("'"&MONTH(E3)&"-"&DAY(E3)&"-"&RIGHT(YEAR(E3),2)&"'!E3")
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,061
    Articles
    0
    Excel Version
    365
    To be able to copy down, in B4, the likes of:
    =A4-INDIRECT(TEXT($B$3,"'mm-dd-yy'!")& CELL("address",A4))
    Last edited by p45cal; 2021-10-29 at 12:12 PM.

  4. #4
    Acolyte chrisl614's Avatar
    Join Date
    Apr 2019
    Posts
    27
    Articles
    0
    Excel Version
    2016
    Thank you to you both!

    The formula provided by p45cal worked perfectly!


    Sent from my iPhone using Tapatalk

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •