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

>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" <(E-Mail Removed)> wrote in message
news:be549ff2-18b3-4db4-ba02-(E-Mail Removed)...
>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
>
>