Let's say I wanted something to occur at specific times (via DDE) on Sunday,
a different thing on Monday -Tue, Wed, Thurs, Fri Sat and continue over and
over.

I see how I can know the day and time, but to use it in a formula escapes
me.
The use is for a simple area based light control in my house.

Hi Vernon

Maybe
=IF(AND(WEEKDAY(NOW())=1,HOUR(NOW())>=8,HOUR(NOW())<=17),"Switch
on","Switch off")

--
Regards

Roger Govier


"vernon" <there@there> wrote in message
news:%(E-Mail Removed)...
> Let's say I wanted something to occur at specific times (via DDE) on
> Sunday, a different thing on Monday -Tue, Wed, Thurs, Fri Sat and
> continue over and over.
>
> I see how I can know the day and time, but to use it in a formula
> escapes me.
> The use is for a simple area based light control in my house.
>