Date patterns (How to enter dates for every Wednesday and Friday)

[evz_2]

I need a formula, way to input the dates of every Wednesday and Friday since 01/07/2105
so for example the dates I require int he pattern would be:

01.07.15 03.07.15 08.07.15 10.07.15 15.07.15 17.07.15

and so on - every Wednesday and Friday.

Rather than typing out the actual date is there a way to automatically do this for time infinity. Once every 7 days is easy. (date +7 and drag). But I am new to this weekday function. If someone could explain and write an example formula it would be ideal and then I could use the concept for any pattern required.

Many thanks

 

[gaz_chops]

Try

=IF(WEEKDAY(A1)=4,A1+2,IF(WEEKDAY(A1)=6,A1+5))

Realised you don't need the 2nd if, so

=IF(WEEKDAY(A1)=4,A1+2,A1+5)