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

Need Help

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

jqnkjq

Copper Contributor

Mar 17, 2024

SergeiBaklan Hi, I have seen your guidance and must appreciate your knowledge. I have tried the same formula, where I want 1 in every cell after the chosen date and the earlier cells with dates should apprear ZERO. The formula isn't working for some reasonhttp://"C:\Users\jq\OneDrive\09 Data JQ\Sample WorkBook.xlsx" . Any guidance will be appreciated. Thank you.

SergeiBaklan

Diamond Contributor

Mar 17, 2024

jqnkjq

Unfortunately link on the file is wrong, it's on your local file mapped with OneDrive. To share outside open OneDrive in browser, for the file to share in 3-dot menu find share, follow instruction to generate the link (be sure file shall be available for everyone) and share the link here.

Base on screenshot. If you have actual dates both in column C and in headers, when it could be like

=IF($C7 <= D$6, 1, 0)

and drag it to the right and down.

If you have texts which looks like dates when we need to parse such texts and convert to actual dates. When we need bit more information, where are dates and where are texts.