halefamily104
New Member
- Joined
- Oct 11, 2016
- Messages
- 31
Hello There!
I have a question. I am trying to find a formula that calculates between two dates, the "next Treatment Due" and today's date and determines if the date in the Next Treatment Due is past due or current. Here's the breakdown. I have three columns. First is named "Last Treatment Completed" (EE95), next is "Next Treatment Due" (EF95) and last is "Treatment Done" (EG95). I need to show in another column if the "Next Treatment Due" is current or past due. Currently, this formula does it:
=IF(ISBLANK(EF95),"",IF(EF95<TODAY(),"Overdue","Not due"))
Here's the problem. in the "Treatment Done" column, a date will be entered so I need to look at that date and change the status to "Current". How can I do this?
Trying this but currently its showing "Overdue" insead of "Current"
=IF(ISBLANK(EF16),"",IF(EF16<TODAY(),"Overdue",OR IF(EG16>TODAY(),"current")))
Thanks in Advance!
I have a question. I am trying to find a formula that calculates between two dates, the "next Treatment Due" and today's date and determines if the date in the Next Treatment Due is past due or current. Here's the breakdown. I have three columns. First is named "Last Treatment Completed" (EE95), next is "Next Treatment Due" (EF95) and last is "Treatment Done" (EG95). I need to show in another column if the "Next Treatment Due" is current or past due. Currently, this formula does it:
=IF(ISBLANK(EF95),"",IF(EF95<TODAY(),"Overdue","Not due"))
Here's the problem. in the "Treatment Done" column, a date will be entered so I need to look at that date and change the status to "Current". How can I do this?
Trying this but currently its showing "Overdue" insead of "Current"
=IF(ISBLANK(EF16),"",IF(EF16<TODAY(),"Overdue",OR IF(EG16>TODAY(),"current")))
Thanks in Advance!