Default to a particular day of week
 

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.

Default to a particular day of week
 

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

"jhicsupt" wrote:

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.

Default to a particular day of week
 

Thanks - it worked great!

"BoniM" wrote:

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

"jhicsupt" wrote:

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.

Default to a particular day of week
 

You are very welcome... happy to help!

"jhicsupt" wrote:

Thanks - it worked great!

"BoniM" wrote:

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

"jhicsupt" wrote:

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.