Display Friday before if weekend, or Friday after if not?

[taeleon]

How would I get Excel to show a date that is either the Friday before if a weekend or the Friday after if not?

For example.

If I enter 26/08/14 the formulated cell would see this is not a weekend so choose the next Friday which is the 29th August. If however I entered 26/09/14 it would see this is a Friday so would just show the same date. If I entered 26/10/14 it would see this is a Sunday so choose the Friday before which is the 24/10/14.

Thanks.

 

[Rick Rothstein]

How would I get Excel to show a date that is either the Friday before if a weekend or the Friday after if not?

For example.

If I enter 26/08/14 the formulated cell would see this is not a weekend so choose the next Friday which is the 29th August. If however I entered 26/09/14 it would see this is a Friday so would just show the same date. If I entered 26/10/14 it would see this is a Sunday so choose the Friday before which is the 24/10/14.

What do you want to get if the given date is a Friday?

 

[barry houdini]

Hello taeleon, welcome to MrExcel

With any date in A1 use this formula in B1

=A1+5-WEEKDAY(A1-1)

 

[taeleon]

Hello taeleon, welcome to MrExcel

With any date in A1 use this formula in B1

=A1+5-WEEKDAY(A1-1)

Hi Barry.

Thanks for the welcome and the answer. It worked as I wanted it to.

Brilliant! Thanks again.