JAeEM New Member Feb 5, 2019 #1 Hi wonderful Excel Gods! My question today is how do I write a formula that will show me dates in a column that are within 90 days of today's date. This is what I got so far but I'm missing something NOW()<=90 Please help thank you all so much for your continued support.
Hi wonderful Excel Gods! My question today is how do I write a formula that will show me dates in a column that are within 90 days of today's date. This is what I got so far but I'm missing something NOW()<=90 Please help thank you all so much for your continued support.
P Peter Bartholomew Well-Known Member Feb 5, 2019 #2 You are missing a reference to your column of dates! = ( date - TODAY() <= 90 ) returns TRUE for dates within 90days and FALSE otherwise. p.s. NOW() would also work.
You are missing a reference to your column of dates! = ( date - TODAY() <= 90 ) returns TRUE for dates within 90days and FALSE otherwise. p.s. NOW() would also work.
