IF function with dates [Solved]

Question

IF function with dates [Solved]

Report

ayudameexcel - Aug 17, 2020 at 10:40 AM
TrowaD

Posts: 2686
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: January 5, 2021

- Aug 20, 2020 at 11:47 AM

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

IF function with dates
If function with dates - How-To - Excel
IF functions with dates ✓ - Forum - Excel
Some help needed about IF function with dates ✓ - Forum - Excel
Using the IF function for dates ✓ - Forum - Excel
Using IF function with dates ✓ - Forum - Excel

1 reply

Reply Ask a question

TrowaD · Answer 1 · 2020-08-20T11:47:20-0400

Answer 1 / 1

TrowaD

Posts: 2686
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: January 5, 2021

452
Aug 20, 2020 at 11:47 AM

Hi Ayudame,

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

Best regards,
Trowa

IF function with dates [Solved]

1 reply

Your reply

Subscribe To Our Newsletter!