Formula based on date Hi, Is there a way to run a formula only if the date in a

Question

Formula based on date

Hi,

Is there a way to run a formula only if the date in a certain cell/column is in the future? I am having trouble as formulas in certain cells are not showing properly as they refer to another cell with a date that has already passed.

Perhaps if it is possible to count the # of days between today and another date with positive numbers meaning in the future and negative numbers in the past so only run the formula if it is positive?

Date format is 15-JAN-2016 if that matters ..

Thanks!

Explanation / Answer

Hi..

Hi,

You can test the date like this

=IF(A2<=TODAY(),your formula here,"")

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.