Excel Date Formula

S

Steve

Can I write a formula to check a cell reference to see if
the date it contains is more than 120 days before today?
 
F

Frank Kabel

Hi
try
=IF(A1<TODAY()-120,"more than 120 before today","within 120 days")
if A1 is the cell to check
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
Vlookup 1
Expanding Date Formula 0
Countif or other formula needed for multiple data/critera results 3
Searching the formula (not the value) for a text string 1
Conditional Formatting Conundrum 3
Excel --> Word 4
How to create a bubble chart with more than 2 variables. 0

Top