Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

IF function with dates [Solved]

Report
-
Posts
2673
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 26, 2020
 -
Hello,

I am trying to get a function to see if a pt needs to have an appointment made.

I have been trying the 'if and function' to see if there's a 'date' in column A and compare it against column B which is the 'appointment status' (either no show or kept appt as the values).

So i'm thinking the formula would see if the a 'date' in column A, read the 'no show status' in column B and then put out a 'yes' in column C so I know they need to be seen.


Please let me know if you have any questions and thank you for your help.





System Configuration: Macintosh / Chrome 84.0.4147.125
See more

1 reply

Answer 1 / 1
Posts
2673
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 26, 2020
 446
Hi Ayudame,

Give the following formula a try:
=IF(AND(ISERROR(TODAY()+A2)=FALSE,B2="no show status"),"yes","")

Best regards,
Trowa
Reply Ask a question