Forum Discussion
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...
Sorry, I forgot to correct the reference when copy/paste your initial formula.
=IF(TODAY()>=DATEVALUE("07/01/2018"), Jun!V24, "")
SergeiBaklan If I didn't want the "total" (N9 in my worksheet) to exceed the inputed "total number of units" (B5 in my worksheet) how can I do that?
thanks
m.
It depends on how your data is structured. Could you please provide small sample file?
- SergeiBaklan , Hi I am doing a planning for some robot to run, what should I insert in the formula bar so that I will have a "x" each alternate 7 days. Excel layout is: COLUMN: DAYS (1-30)
Row: Diff Location (p.s I have a drop down list to choose from jan-dec).
please help
