Coding for a specific day

C

cmatera

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
 
T

T. Valko

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting day names chronologically 5
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Exclude weekends when counting days only on day 29 or 30 3
Excel Message box with days of month & date. 1
business day date from a specific date based on a number of days 2
Counting occurences of a specific day between two dates 1
Function for generating monthly & weekly averages 4

Top