# I need an END Date to fall on a specific DAY.

Options

I need my END Date to fall on a Friday. If my duration takes me to a Thursday, how can I force it to the next occurrence of a Friday? I saw a formula once and can not find it again.

• ✭✭✭✭✭✭
Options

I'm not sure how you are currently populating your end date, but this is the basic idea.

=[End Date]@row - WEEKDAY([End Date]@row) + 6

• Options

Thank you. The formula works but I am using Start - End Dates with durations. Can formula be added to those end dates that I need task to fall on a Friday?

• ✭✭✭✭✭✭
Options

How is [Calendar Days] being calculated? If it is coming from somewhere else, you can use this in [End Date] based off of [Start Date] and [Calendar Days]. If [Calendar Days] is being calculated FROM the start and end days, then you will need some type of helper column.

=([Start Date]@row + [Calendar Days]@row + 1) - WEEKDAY([Start Date]@row + [Calendar Days]@row + 1) +6

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!