Quote Originally Posted by salim ali View Post
try in the cell F1 this formula (Number Format=Short date) and drag to right

HTML Code: 
and in cell F2 this formula (Number Format=general) and drag to right
HTML Code: 
Thank you for the effort but row 1 is for Monday, Tuesday, etc.. Row 2 is for the Dates.

Ill will attach a sample asap.