TechArena Community Formula to compare two dates in Excel

# Formula to compare two dates in Excel

## Windows Software

#1
15-10-2009
 Member Join Date: Dec 2008 Posts: 52
Formula to compare two dates in Excel

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 ,.

#2
15-10-2009
 Member Join Date: May 2008 Posts: 4,339
Re: Formula to compare two dates in Excel

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

Quote:
 =if(A1>B1,"Greater","Less") or =if(A1>B1,"TRUE","FALSE")
#3
15-10-2009
 Member Join Date: Apr 2008 Posts: 2,139
Re: Formula to compare two dates in Excel

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
#4
15-10-2009
 Member Join Date: Apr 2008 Posts: 4,086
Re: Formula to compare two dates in Excel

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
__________________
Ram requirement for various OS

 Tags: