My previous reply was missing a closing paren. Use

=NOW()+CHOOSE(WEEKDAY(NOW()),5,4,3,2,1,0,6)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Chip Pearson" wrote in message
...
Austin,

Try the following formula:
=NOW()+CHOOSE(WEEKDAY(NOW(),5,4,3,2,1,0,6)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Austin M. Horst" wrote
in
message
...
I'm trying to write a formula to return this Friday's date
(Format m/d/yyyy).
If it's a Saturday, I want next weeks Friday to be displayed.

The following works, but takes 7 cells (each formula is in a
different cell).
I would like to combine the following into one formula.

=IF(WEEKDAY(NOW())=1,TODAY()+5,"")
=IF(WEEKDAY(NOW())=2,TODAY()+4,"")
=IF(WEEKDAY(NOW())=3,TODAY()+3,"")
=IF(WEEKDAY(NOW())=4,TODAY()+2,"")
=IF(WEEKDAY(NOW())=5,TODAY()+1,"")
=IF(WEEKDAY(NOW())=6,TODAY()+0,"")
=IF(WEEKDAY(NOW())=7,TODAY()+6,"")

Value returned: 4/30/2004

If I join each line together with an "&" the date is retuned
in
decimal value, not m/d/yyyy.
The "number format" of the cell is Category: Date | Type:
m/dd/yyy
(The following is all on one line in my sheet, I broke it up
here to make it easier to see)

=IF(WEEKDAY(NOW())=1,TODAY()+5,"")&
IF(WEEKDAY(NOW())=2,TODAY()+4,"")&
IF(WEEKDAY(NOW())=3,TODAY()+3,"")&
IF(WEEKDAY(NOW())=4,TODAY()+2,"")&
IF(WEEKDAY(NOW())=5,TODAY()+1,"")&
IF(WEEKDAY(NOW())=6,TODAY()+0,"")&
IF(WEEKDAY(NOW())=7,TODAY()+6,"")

Value returned: 38107

Maybe there is a better way to write this.
Any ideas?

Thanks,
Austin M. Horst