Day of week time control

  • Thread starter Thread starter vernon
  • Start date Start date
V

vernon

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")
 
Back
Top