Forum Discussion

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

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, "")

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.

Copper Contributor

Feb 20, 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

Ashleigh143
Copper Contributor
Mar 29, 2023
James_Pape

Try using ChatGPT to find a formula that works!
- James_Pape
  Copper Contributor
  Apr 08, 2023
  Hey Ashleigh143,
  I am not sure what ChatGPT is. I have never done this so not sure where to start.
  - James_Pape
    Copper Contributor
    May 29, 2023
    James_Pape Ashleigh143
    Well, I have a answer to my problem. My daughter is a security engineer for a bank and I had her set down with me. My original formula only looked at a certain page, PLAYERS!. Well the answer was to create a different PLAYER! sheet for each week. So, I have PLAYERS1, PLAYERS2, and so on. These are pointed to by each week in my "MATHCH PLAY TWO" sheet.
    So my final formula for each week looks like this.
    =INDEX(PLAYING8!$E$1:$G$200,MATCH(AQ4,PLAYING8!$E$1:PLAYING8!$E$200,0),2)
    Which is week 8s column.
    So, when my PLAYING sheet is updated I just copy and paste the information into the PLAYING? week that we are working on. Cures all my issues and I am looking back and laughing at myself.
    Thanks again for you help.
    Jim