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.

Answers

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    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

  • MarkAllen
    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?


  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    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!