View Single Post
  #4   Report Post  
CyberTaz
 
Posts: n/a
Default

If you want to do the same thing without writing an expression, you can
simply use the Fill command as follows:

1) Enter a start date and select that cell plus as many additional cells as
necessary,

2) Go to EditFillSeries and select Weekday from the right column (labeled
Date unit).

Hope this is useful |:)

"Akhilesh Dalia" wrote:

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