Hi Bob,

You have provided a great help! It works fantastic....

Thanks a lot!!

Regards
Akhilesh Dalia
akhileshdalia<athotmail<dotcom

"Bob Phillips" wrote:

You could put a date in A1, then in B1 add

=A1+1+(WEEKDAY(A1)=6)*2

then drag that formula down

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Akhilesh Dalia" wrote in message
...
I entered a date in A1 and dragged it, due to dragging it increase at the
interval of one. I want to jump my date two times at the end of the week.
Simply I want to jump my weekly off and want only working days by dragging
it. Please help.

Regards

Akhilesh Dalia
akhileshdalia<athotmail<dotcom