ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Weekly Schedule (https://www.excelbanter.com/excel-discussion-misc-queries/117534-weekly-schedule.html)

nicole1

Weekly Schedule
 
I travel one new place per week. I stay Tuesday thru Sunday. How do I make
a weekly schedule that doesn't include the separate days. Example:
November 7-12 Des Moines, IA
November 14-19 St. Louis, MO

And is there a way to make it continue the list, and skip Mondays? Please
let me know.
Thanks so much!

RagDyeR

Weekly Schedule
 
One easy way to do it is to use 2 columns per visit.

A B
11/7 11/12
11/14 11/19

Now, select all 4 cells, and drag down.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"nicole1" wrote in message
...
I travel one new place per week. I stay Tuesday thru Sunday. How do I

make
a weekly schedule that doesn't include the separate days. Example:
November 7-12 Des Moines, IA
November 14-19 St. Louis, MO

And is there a way to make it continue the list, and skip Mondays? Please
let me know.
Thanks so much!




All times are GMT +1. The time now is 02:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com