(Msg. 1) Posted: Mon Aug 18, 2008 1:03 pm
Post subject: Coding for a specific day Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
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?
(Msg. 2) Posted: Mon Aug 18, 2008 4:22 pm
Post subject: Re: Coding for a specific day [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
>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" <cmatera.RemoveThis@gmail.com> wrote in message
news:be549ff2-18b3-4db4-ba02-d4e75afee287@c58g2000hsc.googlegroups.com...
>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
>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office