Excel Templates | Excel Spreadsheets | TV Schedule



TV Schedule

Posted on October 29, 2009
Filed Under Calendar |



There is a request from people about a possibility to have a calendar where they can customize their favourite TV shows in that calendar. So, they will easily being reminded by the calendar about the date and the time of their favourite TV shows.

TV Schedule

This is the solution of that request where you can easily list your TV shows and let the excel formula display your listing in weekly calendar. This TV schedule will display the date, the time, the TV station and the TV shows. And you can slide right or left to customize the weekly period before you print it.

This TV schedule consists of two worksheets. The first worksheet is TV listing worksheet where you can list your favourite TV shows based on recurring day (for example Heroes movie that is aired every Monday), recurring date (for example Music live show event that occur once a month), or fixed date (for example a Los Angeles Lakers matches). There is a holiday column where you can customize if you have other holidays date instead of default USA holidays.

TV Schedule Setup

Once you finished listing your TV shows, you can go to the second worksheet and see how the formula organize your listing in corresponding day and dates. Input the starting date for slider bar reference. And after that you can slide right or slide left to customize the weekly period of TV schedule.

You can download the file here.


You can read and download my other templates below :

Tags: , , , , ,

Comments

5 Responses to “TV Schedule”

  1. muaz on January 15th, 2010 8:46 am

    can u pls provide me the password of ’schedule’ sheet?? i want to edit all sundays.. bcox our public holiday is friday and saturday
    thank u in advance
    B.Regards
    Muaz

  2. muaz on January 19th, 2010 7:30 pm

    i hav uprotected the sheet schedule.. btw can u pls tell me why all sundays and holidays are red?

  3. Kumar on February 5th, 2010 3:50 pm

    Sir,

    U have done the great thing , these sheets r very helpful.

    Thanks a lot.

    Regards,
    Aman Kumar

  4. Willy on March 30th, 2010 3:48 pm

    Dear Sir,

    I enjoyed your templates for F1 and The World Cup and I also liked the TV schedules. However, in the pull-down menu for recurring days, ‘SUNDAY’ is not listed. I would appreciate if you can tell me how to go about to include ‘SUNDAY’on the pull down menu. Thank You

    Regards
    Willy

  5. terry on May 25th, 2010 5:14 pm

    Can you tell me how to restrict the day number to 31 day ~
    As I press the “Next” button ~the calender can keep on going until a day that is not specify ~~><! It makes me feel confused a bit ~~

    What I mean is when the “start date” has been set to January~and when I click the “Next” button, the date showing below cannot more that month ~~

    Do you know what I mean ?

    Please get back to me ~thanks alot

Leave a Reply