Formula with Dates

I am trying to reference another sheet where that column will be marked "completed" and then using the star symbol, have it toggled on if the date is in the month of January.

Any help is appreciated! I'm new at this :)

=IF({RANGE 1}, "Completed", IF(AND({RANGE 2}, <=DATE(2022, 1, 31), {RANGE 2}, >=DATE(2022, 1, 1), 1, 0)))

Find more posts tagged with

Formulas

Accepted answers

All comments

Gia Thinh

Hi @cicconebeth,

Assume that {RANGE 1} and {RANGE 2} are cells in the reference sheet. Let's make the formula simpler:

=IF({RANGE 1}, "Completed", IF(MONTH({RANGE 2})=1, 1, 0)))

Hope it works.

cicconebeth

Unfortunately, that is giving me an INVALID DATA TYPE error.

Yes, Range 1 and 2 are cells on a reference sheet.

This is screenshot ex is for Feb, but I will be doing this for all months

So if it's marked "Completed" and the end date is within that month, then I want to star symbol to be toggled on. Hope this clarifies what I'm attempting to do.

Thanks!

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.