IF Statements with Dates

Hi all,

I am clearly missing something…

I have a sheet with columns for the Start and Date Ends and then another column to track the Status (In Progress, Enrolled/Upcoming, Completed). The formula is currently:

=IF([Start Date]@row > TODAY(), "Enrolled", IF([Start Date]@row < TODAY(), "In Progress", IF([End Date]@row < TODAY(), "Completed")))

How can I correctly incorporate a "Completed" Status once the End Date changes to be a date in the past?

Any ideas? Thank you!

Find more posts tagged with

IF(OR

IF(AND

dates

TODAY()

if formula

Accepted answers

VBAGuru

With the tags, I think you are on the right track. The following is using the logic that if the end date is less that today, it is completed. If that is not the case, then if the start date is in the future, then, enrolled. Otherwise, not meeting either of those two, it is in progress.

=IF([End Date]@row < TODAY(), "Completed", IF([Start Date]@row > TODAY(), "Enrolled", "In Progress"))

All comments

VBAGuru

=IF([End Date]@row < TODAY(), "Completed", IF([Start Date]@row > TODAY(), "Enrolled", "In Progress"))

Elizabeth N

Thank you! I knew I was missing something. That makes sense. :)

VBAGuru

Glad I could help!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.