IFERROR and january dates for previous month (and Year)

Happy New Year All.

I have successfully had help in navigating the problems of "Previus" month when a new year like now for both COUNTIFS and SUMIFS

However, I have a simple IF statement and just cannot get it to work.

4 fields

Date & Time - this is the automated date creation value

This Month - dropdown with True or False values calculated by formula
=IF(DATE(YEAR([Date & Time]@row), MONTH([Date & Time]@row), 1) = DATE(YEAR(TODAY()), MONTH(TODAY()), 1), "True", "False")
which still works OK (phew)

Last Month - dropdown with True or False values calculated by formula
=IF(DATE(YEAR([Date & Time]@row), MONTH([Date & Time]@row), 1) = DATE(YEAR(TODAY()), (MONTH(TODAY()) - 1), 1), "True", "False")
which of course goes wrong this month as need to remove 1 from year and set month = 12

Previous Month - dropdown with True or False values calculated by formula
=IF(DATE(YEAR([Date & Time]@row), MONTH([Date & Time]@row), 1) = DATE(YEAR(TODAY()), (MONTH(TODAY()) - 2), 1), "True", "False")
which of course goes wrong this month as need to remove 1 from year and set month = 12

Now I have tried adding in IFERROR statements but whatever I try comes back #UNPARSEABLE
=IF(DATE(YEAR([Date & Time]@row, MONTH([Date & Time]@row,1) = IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) -1,1), DATE(YEAR(TODAY()) -1, 12, 1))), "True", False")

So I am stuck and really hope someone can help me as my brain just cannot push thrugh this one.

Many thanks in anticipation

Sue

Find more posts tagged with

Formulas

dates

Accepted answers

SueinSpain

Well it took a bit of reqording to explain what I wanted but AI seems to have fixed it a completely different way.

I have posted the results here for anyone lese who is interested

this month =
=IF(AND(MONTH([Date & Time]@row) = MONTH(TODAY()), YEAR([Date & Time]@row) = YEAR(TODAY())), "True", "False")

last month =
=IF(OR(AND(MONTH([Date & Time]@row) = MONTH(TODAY()) - 1, YEAR([Date & Time]@row) = YEAR(TODAY())), AND(MONTH(TODAY()) = 1, MONTH([Date & Time]@row) = 12, YEAR([Date & Time]@row) = YEAR(TODAY()) - 1)), "True", "False")

previous month =

=IF(OR(AND(MONTH([Date & Time]@row) = IF(MONTH(TODAY()) = 1, 11, IF(MONTH(TODAY()) = 2, 12, MONTH(TODAY()) - 2)), YEAR([Date & Time]@row) = IF(OR(MONTH(TODAY()) = 1, MONTH(TODAY()) = 2), YEAR(TODAY()) - 1, YEAR(TODAY()))), AND(MONTH([Date & Time]@row) = MONTH(TODAY()) - 2, YEAR([Date & Time]@row) = YEAR(TODAY()))), "True", "False")

Not sure my brain can unwrap what has been coded as so many brackets, ifs, ors, ands etc. but it seems to work for now. I'll wait to see if I have it correct for previous month in February

Happy new year all

All comments

SueinSpain

Well it took a bit of reqording to explain what I wanted but AI seems to have fixed it a completely different way.

I have posted the results here for anyone lese who is interested

this month =
=IF(AND(MONTH([Date & Time]@row) = MONTH(TODAY()), YEAR([Date & Time]@row) = YEAR(TODAY())), "True", "False")

previous month =

Not sure my brain can unwrap what has been coded as so many brackets, ifs, ors, ands etc. but it seems to work for now. I'll wait to see if I have it correct for previous month in February

Happy new year all

Georgie

Hey @SueinSpain,

Thank you for posting your solution. I'm glad you got this resolved!

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.