Find Saturdays using formula :)

**chloesnowling** · 01-15-2010, 05:08 AM

Hi,

I have the following list of information (but for the whole year).

I want a formula to say if the day equals Saturday then give me the date.

I want to end up with a list of the saturday dates.

A1 A2
Day Date
Friday 01/01/2010
Saturday 02/01/2010
Sunday 03/01/2010
Monday 04/01/2010
Tuesday 05/01/2010
Wednesday06/01/2010
Thursday 07/01/2010
Friday 08/01/2010
Saturday 09/01/2010

Thank You In Advance!!

**royUK** · 01-15-2010, 05:24 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Thread Title edited this time!

**royUK** · 01-15-2010, 05:29 AM

In the adjacent column add this formula & copy down

=IF(WEEKDAY(A1,2)=6,A1,"")

Now you shoud have a list of all Saturdays, AutoFilter the list for non-blanks to remove the blanks

**pike** · 01-15-2010, 05:34 AM

Hi Chloesnowling
or
Three formulae
D1=IF(A1="Saturday",ROW(),"") fill down to D10
E1=IF(ROW(A1)-ROW(A$1)+1>COUNT(D1:D10),"",INDEX(A:A,SMALL(D1:D10,1+ROW(A1)-ROW(A$1)))) fill down to E10
F1=IF(ROW(A1)-ROW(A$1)+1>COUNT(D1:D10),"",OFFSET(INDEX(A:A,SMALL(D1:D10,1+ROW(A1)-ROW(A$1))),0,1)) fill down to F10