PDA

View Full Version : Solved: Changing default weekday



YasserKhalil
07-28-2010, 01:34 AM
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
07-28-2010, 01:44 AM
I don't think it can be modified Yasser, but you could use a simple formula.

YasserKhalil
07-28-2010, 01:54 AM
Thanks Mr. xld (The Great Helper) for your quick reply
What's the simple formula that will help solving me problem??

Bob Phillips
07-28-2010, 02:28 AM
Put the start date in G1, then in G2:Gn add this

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

YasserKhalil
07-28-2010, 02:42 AM
Perfect Mr. xld
Thank you very much
You're really (The Great Helper)