Solved: Changing default weekday

[YasserKhalil]

Hi guys
When I tried to make a series of dates using Fill >> Series >> Type: Date >> Date Unit : Weekday ..
I found that it excludes the Saturdays and Sundays as holidays ...
I want the weekday to be Fridays only

[Bob Phillips]

I don't think it can be modified Yasser, but you could use a simple formula.

[YasserKhalil]

Thanks Mr. xld (The Great Helper) for your quick reply
What's the simple formula that will help solving me problem??

[Bob Phillips]

Put the start date in G1, then in G2:Gn add this

=IF(WEEKDAY(G1)=5,G1+2,G1+1)

[YasserKhalil]

Perfect Mr. xld
Thank you very much
You're really (The Great Helper)