Formula to compare two dates in Excel

[zaid]

Hello,

Here, I am a Noob in office, and yet I would like you help me a little in writing a formula that allows me to do this: I have a table in excel ,I would like create a formula that allows me to compare two dates ,in my table there is a list of patients (A) and the dates of their last visit (B) , I want to compare the date of their last visit date with todays date , so that I could send mail only to those who did not came for 3 months , can you help me in writing the formula , Thank you for your answer ,.

[JonathanD]

You can check this Formula to compare two dates in Excel , it might work for you

=if(A1>B1,"Greater","Less")

or

=if(A1>B1,"TRUE","FALSE")

[chroma]

I propose the formula

C2 = IF(TODAY()-B2>90, 1, 0)

90 days = 3 months , You need to copy the formula as it is paste in the office excdel

Best regards

[ThoMas321]

The simplest (and "better") is to put your reference date in a cell and use its coordinates

To find the number of days between now and a date sometime in the future, use the following formula

="mm/dd/yy"-TODAY()

where "mm/dd/yy" is the future date. Use the General format to format the cell that contains the formula.

maybe somebody can modify these to find a difference between these date