ExcelBanter - Trying to make cell "date sensitive" to specific date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Trying to make cell "date sensitive" to specific date (https://www.excelbanter.com/excel-discussion-misc-queries/4231-trying-make-cell-%22date-sensitive%22-specific-date.html)

ebuzz13

Trying to make cell "date sensitive" to specific date

How do I make a cell "date sensitive" to calculate a formula or input a value
on a specific date?

JE McGimpsey

I suppose something like:

=IF(TODAY()="1/18/2005", <your formula here,"")

In article ,
"ebuzz13" wrote:

How do I make a cell "date sensitive" to calculate a formula or input a value
on a specific date?

All times are GMT +1. The time now is 11:22 AM.