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

MarkAllen

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.

Carson Penticuff

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

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

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