Ask Search:
Jo KnollJo Knoll 

Formula field to compare dates. Help!

How can I have a following checkbox checked when:

Date Field (Estimation Date) is within 75 days of current day. 

Thank you community!
Best Answer chosen by Jo Knoll
Mayank SrivastavaMayank Srivastava
Jo, just use this:
AND(
    DATEVALUE(Estimation_Field__c) <= TODAY(),
    DATEVALUE(Estimation_Field__c) + 75 >= TODAY()
)
Let me know if it doesn't work as expected.

All Answers

Jo KnollJo Knoll
Also, the date field is a date time field and this date time field cannot be greater than current day. 
Mayank SrivastavaMayank Srivastava
Jo, just use this:
AND(
    DATEVALUE(Estimation_Field__c) <= TODAY(),
    DATEVALUE(Estimation_Field__c) + 75 >= TODAY()
)
Let me know if it doesn't work as expected.
This was selected as the best answer