Default to a particular day of week

[jhicsupt]

I would like to default to a Friday when a date is entered in a cell. For
example:

Cell A2 = 4/2/07
Cell A3 should default to 4/6/07

So for any date from Saturday to Friday would default to the Friday.

Thanks in advance.

 

[BoniM]

=A2+IF(WEEKDAY(A2)=7,13-WEEKDAY(A2),6-WEEKDAY(A2))

 

[jhicsupt]

Thanks - it worked great!

=A2+IF(WEEKDAY(A2)=7,13-WEEKDAY(A2),6-WEEKDAY(A2))

 

[BoniM]

You are very welcome... happy to help!

Thanks - it worked great!