Thread: Default to a particular day of week
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
jhicsupt jhicsupt is offline
external usenet poster
  
Posts: 25
Default 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.
Reply With QuoteReply With Quote