Formula to calculate the Thursday after a specific date

X M

Hi

I have a cell containing the date at which some engineering tasks are completed (Complete date). I need to display in a separate cell the release date which is the new Thursday following the Complete date (or the Complete date if the Complete date is a Thursday)

In a previous thread I found the following formula which works to calculate the next Monday

=IF(WEEKDAY(Date@row) = 1, Date@row - (WEEKDAY(Date@row) - 5), Date@row - (WEEKDAY(Date@row) - 5) + 7)

but I cannot figure out how this formula works and how to modify it to make it work for Thursday.

Thank you for your help in advance

Xavier..

Bassam Khalil

Hi @xav 

Hope you are fine, please try the following formula:

=IF(WEEKDAY(Date@row) = 5, Date@row, Date@row - (WEEKDAY(Date@row) - 5) + 7)

Bassam Khalil

Hi @xav 

Hope you are fine, please try the following formula:

=IF(WEEKDAY(Date@row) = 5, Date@row, Date@row - (WEEKDAY(Date@row) - 5) + 7)

X M

Thanks Bassam

Bassam Khalil

@xav

You are welcome

X M

@Bassam.M Khalil

Hi Bassam, it seems that my requirements were not clear enough for that formula.

When I enter a date between Monday and Wednesday I need the formula to retrieve the upcoming Thursday of the same week. When I enter a date after after the Thursday of the week , it should retrieve the Thursday of the following week.

Here are the user cases:

• if 03/14, 03/15, 03/16 or 3/17 is the date entered, the formula should retrieve 03/18
• if 03/18 is the date entered the formula should retrieve 03/18
• if 03/19 is the date entered the formula should retrieve 03/25

Does that make sense?

Thanks

Xavier..