+ Reply to Thread
Results 1 to 3 of 3

Making a list with dates...

  1. #1
    Registered User
    Join Date
    09-30-2010
    Location
    Tielt, Belgium
    MS-Off Ver
    Excel 2010
    Posts
    2

    Lightbulb Making a list with dates...

    Hi. I am new to this forum. I have been around on other excel forums, but as nobody ever replied to one of my questions, I'm trying again here...

    I am looking for two formulas.
    The first one:
    A formula I can use for making a "dragable" row of all mondays, tuesdays, thursdays and fridays of one month.

    In the other formula, I want mondays, tuesdays, wednessdays, thursdays, and fridays.



    For now I use this formula:

    =date("cell with year";"cell with month";"cell with day")

    The problem is that I don't want any saturdays or sundays.

    In the other spreadsheet, I don't want any saturdays, sundays and wednessdays.

    Can anybody help me out on this one?
    Attached Files Attached Files
    Last edited by Jasperman; 09-30-2010 at 04:36 PM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Making a list with dates...

    It would help if you uploaded a spreadsheet showing how you want it to look. (Go Advanced>Manage Attachments)
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    09-30-2010
    Location
    Tielt, Belgium
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Making a list with dates...

    There you go!

    I'll try to explain what it has to be used for...

    I'm a teacher. Everyday, the kids can choose what they want for a drink after the break... They can have a drink every monday, tuesday, wednessday, thursday and friday.
    I have to write down what they order each day.

    I want to make a spreadsheet so that I don't have to change the yellow part by hand everytime we enter a new month. I just want to be able to set the month and the year, and then I want a list with all mondays, tuesdays, wednesdays, thursdays, fridays...
    You'll see that I found that allmost. ==> the only problem is that if a month starts on a saturday or sunday...

    For the second tab, I need exactly the same thing, but this is not for drinks, but for meals. The childeren can have a lunch every monday, tuesday, thursday and friday.
    So I only want those days displayed in the yellow part.
    Again I don't want to change everything when we enter a new month...
    I hope you understand what I'm looking for here...

    Thanks in advance

    Jasperman

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1