You are right but your formula won't work in conditional formatting since it
is part of the ATP add-in unless you refer to another cell first

=$B1=TODAY()+CHOOSE(WEEKDAY(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())),2),1,1,1,1,3,2,1)

will work albeit ugly


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:%23Bo47iAZGHA.3400@TK2MSFTNGP02.phx.gbl...
>I think you want
>
> =B1=WORKDAY(TODAY(),1)
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com> wrote in message
> news:%23w5O01$YGHA.3532@TK2MSFTNGP05.phx.gbl...
>> One possible way:
>>
>> Assume the dates start in B1 going down, select the whole range, do
>> format
>> conditional formatting, formula is and use
>>
>> =AND($B1-TODAY()=1,WEEKDAY($B1,2)<6)
>>
>>
>> select a format to apply and click OK twice
>>
>>
>>
>> --
>>
>> Regards,
>>
>> Peo Sjoblom
>>
>> http://nwexcelsolutions.com
>>
>>
>> "Brian" <Brian@discussions.microsoft.com> wrote in message
>> news:5FEA3E21-0B1C-4240-B36C-211E1ED809B4@microsoft.com...
>> > At the top of my spreadsheet, I have the formula @today()
>> > In Column B, I have a list of dates....
>> > I'd like for an entire row to change color if the date in Column B is
> the
>> > next business day from the @today() date.
>> > How can I do this with conditional formatting?
>>
>>
>
>