Dates

T

Troy

B2 = "5-12-03"
How do I make it check to see if the date in B2 exceeds 6
months (compared to the system clock) then enter C2 in red
text.
 

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

Formatting question: how to format duration (time spent)? 0
Conditional Formatting Less Than Today Week Days only 0
countifs Function not giving desired result with date criteria 2
Think I need a MAX / MIN formula here (help needed) 5
Copying formulas across columns 2
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Can I use the NOW() function in a formula? 2
Difference Between Dates WITH Conditional Formatting 2

Top