Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to create a calendar showing ONLY all the Wednesdays and Thursdays in a year with their date, so for example:
Wed 25 Sept
Thu 26 Sept
Wed 2 October
Thu 3 October
etc.
I thought it would be a simple fill function!

share|improve this question
2  
well, since Excel stores dates as numbers, you can simply iterate a date that is Wed and simply add 7 to it over and over again. –  Doktoro Reichard Aug 23 '13 at 11:31
    
Read this article how to get first Wednesday of year. The Thursday is one day later, the next Wednesday is 7 days later. –  Voitcus Aug 23 '13 at 11:34

1 Answer 1

The formula to get your first Wednesday of the year could be (based on this article):

=DATE(YEAR(A1); 1; 8)-WEEKDAY(DATE(YEAR(A1); 1; 4))

(assuming that A1 has the year you are referring to).

The next day is Thursday, so A3 has

= A2 + 1

The next Wednesday would be A4

= A2 + 7

Now mark A3 and A4 and pull down to propagate.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.