# FIRST OF THE MONTH AFTER 60 DAYS

Options
✭✭
edited 12/09/19

I am trying to auto populate effective dates for benefits and I cannot get the calculation to work past the first part (60 days after start date)

I need to have the following result as an example

Start date: 1/15/2020

Effective Date: 4/1/2020

Thanks!

• ✭✭✭✭✭✭
Options

Hi Ana,

Try something like this.

=DATEONLY([Start Date]@row + 60)

Did it work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
edited 10/08/19
Options

Andree,

I think they are trying to populate the 1st of whatever month is 60 days out.

If that is the case, I would suggest something like this...

=DATE(YEAR([Start Date]@row + 60), MONTH([Start Date]@row + 60), 1)

EDIT to show the first of the month FOLLOWING 60 days and to account for overlap into the following year...

=IFERROR(DATE(YEAR([Start Date]@row + 60), MONTH([Start Date]@row + 60) + 1, 1), DATE(YEAR([Start Date]@row + 60) + 1, MONTH([Start Date]@row) - 9, 1))

• ✭✭✭✭✭✭
Options

Paul,

Yes, you're correct! I missed that part.

Thanks!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

I'm using this formula for the same reason, benefit eligibility, however, if the hire date is the first day of the month, this formula won't give the correct date. For example, if the hire date is March 1, it will give an eligibility date of May 1, when it needs to be June 1. Do you have a way to correct this?

Thanks!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!