Forum Discussion

Sam Maw's avatar
Sam Maw
Copper Contributor
Jun 06, 2018
Solved

Can I make a cell value appear only after a certain date?

Hello, I'm a beginner here. Is there a formula or function I can use (perhaps a =IF?) where I can make a certain formula's value appear in a cell only after a certain date?  Context: on each month...
Formulas & Functions
Need Help
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 06, 2018

    Sorry, I forgot to correct the reference when copy/paste your initial formula.

     =IF(TODAY()>=DATEVALUE("07/01/2018"), Jun!V24, "")

     

James_Pape's avatar
James_Pape
Copper Contributor
Feb 08, 2023
This discussion really helped my issue. I calculate on a specific date but once the date passes the formula wipes out my information. How do I get the formula to function on one day and retain that information once the date passes.
=IF(TODAY()=DATEVALUE("2023-02-07"),INDEX(PLAYING!$E$1:$G$200,MATCH(DE4,PLAYING!$E$1:PLAYING!$E$200,0),2))

TEAM # GROSS HDCP 14 L
ACOBA, JEFF 25 11 14 L
formula resides in cell and looks at ACOBA, JEFF and finds his handicap (11) and populates. I want this to populate on correct date but once that date passes I want the information to stay and not change. Help please.
Adrienne_Ali's avatar
Adrienne_Ali
Copper Contributor
Feb 16, 2023

James_Pape   I was able to work with a colleague and he helped me find the way.  It appears two calendar days after the date in the top of the column.  you can adjust it to not have the "+2".  It appears with the date you indicate and stays there.      

 

"=IF(TODAY()>=(N$2+2),VLOOKUP(N$2,'H:\"  the rest of my formula is after the H.  but the part you need is, "=IF(TODAY()>=(N$2+2),"  the N2 cell is where i have the current date, in row 2.

 

I hope I understood your question and this helps you.    

  • James_Pape's avatar
    James_Pape
    Copper Contributor
    Feb 19, 2023

    Adrienne_Ali 

    Thank You for your efforts.  But, still have an issue.

    I understand your "=IF(TODAY()>=(N$2+2)"

    =IF(TODAY()=(DD$2+2),INDEX(PLAYING!$E$1:$G$200,MATCH(DE4,PLAYING!$E$1:PLAYING!$E$200,0),2))

    This does calculate my cell two days prior to current date which I can work with, but, once the date has passed the formula returns a "false" there for removing the number that I need to stay.

    I included my sheet so you can look at it.  I made my changes to Week 19, DE4 and used DD2 for date info.  

    What I am looking for is for DG4 to calculate on a certain day.  Your addition calculates 2 days after date in DD2.  On third Day DG4 reverts to a "FALSE" and clears my number.  I need it to calculate on a certain day and retain that information for 18 weeks in that cell DG4.  Because the number that it is looking up can change from week to week.

    So what I do now is calculate all players in column DG and then copy and paste value each week.  But I can not figure out how to keep the numbers in DG from changing once it has calculated on its correct date.

    I hope this makes sense.

    Thank You

    James Pape

    • Adrienne_Ali's avatar
      Adrienne_Ali
      Copper Contributor
      Feb 20, 2023
      It does makes sense, but what you need is beyond my scope of Excel. I am sorry. Perhaps someone reading these threads can chime in and help you.
      • James_Pape's avatar
        James_Pape
        Copper Contributor
        Feb 21, 2023
        Adrienne, Thank you for your efforts. I will keep trying to find a solution. I know there has to be but so far it has escaped me.
        Jim

Resources