Coding for a specific day
 

I had a question about dates and times before and you all were very
helpful so thank you - here's another question :-)

Is there a way to code in excel for a specific day... like

If the day = sat or sunday then do XXXXX

Also is there a good..site that lists a lot of date specific
functions?

Thanks for the help!

-Chris

Coding for a specific day
 

If the day = sat or sunday then do XXXXX

If what day? Today's date? Or a date in a cell?

If the day is today:

=IF(WEEKDAY(TODAY(),2)5,"do this","do that")

If the day is a date in a cell:

=IF(WEEKDAY(A1,2)5,"do this","do that")


--
Biff
Microsoft Excel MVP


"cmatera" wrote in message
...
I had a question about dates and times before and you all were very
helpful so thank you - here's another question :-)

Is there a way to code in excel for a specific day... like

If the day = sat or sunday then do XXXXX

Also is there a good..site that lists a lot of date specific
functions?

Thanks for the help!

-Chris