Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Formula to compare two dates in Excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 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 ,.

Reply With Quote
  #2  
Old 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")
Reply With Quote
  #3  
Old 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
Reply With Quote
  #4  
Old 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
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Formula to compare two dates in Excel"
Thread Thread Starter Forum Replies Last Post
How to Calculate Expiration Dates in Excel Kungfu Pandey Windows Software 1 07-01-2012 04:22 PM
importing dates from ms excel into ms project tazor Microsoft Project 2 14-12-2011 10:20 PM
Import from Excel - dates changed niravrph Microsoft Project 4 19-04-2011 08:01 PM
Checking dates in Excel microam_i Windows Software 3 02-05-2009 10:15 PM
How to calculate two dates in Excel Ektaa Windows Software 5 03-03-2009 05:50 PM


All times are GMT +5.5. The time now is 08:43 PM.