Can I get some help on a Date Formula?

Hi SS Community,

I'm currently using a preventative maintenance sheet where I have a "Frequency (Months)", "Last Maintenance Date", and "Next Maintenance Date" column. I am looking to utilize the Frequency to determine what the Next Maintenance Date is via a formula. I'm having a bit of trouble as this is slightly different than how I am used to in excel. Could I get one of you experts to chime in how I can resolve the issue I am having below? Thanks!

My Main issue is that when I use =DATE(YEAR([Last Maintenance/Inspection]@row), MONTH([Last Maintenance/Inspection]@row) + [Frequency (Month)]@row, DAY([Last Maintenance/Inspection]@row))

I run into an issue where if the month exceeds 12 it will throw an error when adding it instead of it calculating into the next year. Thanks

Here's a photo image of my problem:

Find more posts tagged with

Accepted answers

All comments

Razetto

@andrewmezzo I think that you need to turn your frequency into days from months for it to work without dissenting the date formula. Say that a new column,[new freq], is for calculating the avg. number of days in a month, then =[new freq]+[Last Maintenance/Inspection].

andrewmezzo

I converted it to a duration column and use days now, though it doesnt look as appealing as being able to use months as the frequency.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.