You are viewing limited content. For full access, please sign in.

Question

Question

How do I calculate the 1st day of the month after a full 30 days of employment?

Forms
Updated June 13, 2016
asked on June 13, 2016 • Show version history

I need to calculate a date for effective insurance coverage.  Our policy states that insurance becomes effective on the first day of the month after the employee has been employed a full 30 days.  For example if the employee started on June 6th their insurance would become effective on August 1st.  How can I use the employees hire date to populate the effective coverage date?

0 0

Replies

replied on June 13, 2016

=EOMONTH(Date ,1 )+1, where "Date" was the variable for the employment start date. "EOMONTH(date, months)" rounds the date specified as the first argument to the last day of the month after the number of months specified in the second argument. So, for anything in June, you'd get Jul 31. "+1" at the end adds a day, converting July 31 to Aug 1.

1 0
replied on June 13, 2016

Thank you that worked perfect!

0 0
replied on June 13, 2016

Thank you that worked perfect!

replied on June 13, 2016

What product are we talking about? Workflow? Forms?

0 0
replied on June 13, 2016

Forms 10

0 0
replied on June 13, 2016

Thank you that worked perfect!

replied on June 13, 2016

Thank you that worked perfect!

replied on June 13, 2016

Thank you that worked perfect!

replied on May 25, 2017 • Show version history

Hello Everybody,

I'm working on similar Form and trying to calculate end of the month to populate data field. Two fields are specified in the Form - From, which is a Date field populated by JavaScript and To date field - should be automatically populated by formula to show end of the month of the date from From field. It does not work until i manually change the From date. Any advice?

Thank you,

replied on May 25, 2017

In your JS after you set the date in the "From" field, try also triggering a change.

You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...