Edate formula

smartuser2021

I want to calculate the contract expiry date based on the current contract term.

If the day of start date <=15, the expiry date should be the last day of the previous month

if the day of start date is the expiry date should be the last day of the current month

any help would be great

thank you

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Try something like this...

=IF(DAY([Current Contract Start Date]@row)<= 15, DATE(YEAR([Current Contract Start Date]@row), MONTH([Current Contract Start Date]@row), 1), IFERROR(DATE(YEAR([Current Contract Start Date]@row), MONTH([Current Contract Start Date]@row) + 1, 1), DATE(YEAR([Current Contract Start Date]@row) + 1, 1, 1))) - 1

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.