calculations of weekends only

T

tmj8901

I would like to create a spreadsheet where I can I can exclude weekdays. I
want to only show weekends for this year, 2009
 
B

Bob

in a column next to the date use this formula:
=IF(WEEKDAY(<cell your date is in>)=1,"Weekend",IF(WEEKDAY((<cell your date
is in>)=7,"Weekend","Weekday"))

filter for weekend to show Saturday and Sunday dates.
 
R

Ron Rosenfeld

I would like to create a spreadsheet where I can I can exclude weekdays. I
want to only show weekends for this year, 2009
Click to expand...

To obtain the first weekend day of "this" year, you can use this formula:

=MIN(DATE(YEAR(TODAY()),1,1)+7-WEEKDAY(DATE(YEAR(TODAY()),1,1)),
DATE(YEAR(TODAY()),1,1)+7-WEEKDAY(DATE(YEAR(TODAY()),1,1)+6))

If that formula is in D1, then

D2: =IF(WEEKDAY(D1)=7,D1+1,D1+6)

and fill down will return only the weekend (Sat/Sun) days.

If you want to "fix" the year, replace YEAR(TODAY()) in the above formula with
whatever year you want to start at.
--ron
 

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

Excel: counting times and dates during non-traditional hours 0
How can I count the number of SATURDAYS in a month? 2
Calculating days spent to complete a task 2
How to calculate dates 6
Determining the Sunday date of the third "full" weekend of a month 26
Calculate days help 2
Calculate End Date (excluding weekends and holidays) 6
Conditional formatting excluding weekends and holidays 1

Top