Calculating a list of weekdays

Discussion in 'Mac Apps and Mac App Store' started by kmaute, Nov 30, 2010.

  1. kmaute macrumors 6502

    kmaute

    Joined:
    Oct 5, 2008
    Location:
    USA
    #1
    Hey,

    I'm having an issue that I can't figure out. Hopefully someone here will have an idea or two. I need to create a list of specific weekdays with dates from on out. In other words, I need to know the dates of all Sundays and Tuesdays from 12/1/10 to 12/31/12. Ideally, I'd like it do be in an excel or csv format so I could easily manipulate the data. Any ideas on how to do this easily? Thanks.
     
  2. dknightd macrumors 6502

    Joined:
    Mar 7, 2004
    #2
    You should be able to do this in excel. Pick a sunday - make a series that repeats every 7 days. Repeat for Tuesday. Or use iCal. Repeating once a week should be easy for either.
     
  3. Gregg2 macrumors 603

    Joined:
    May 22, 2008
    Location:
    Milwaukee, WI
    #3
    Well, 12/7/10 is a Tuesday. Enter that in a cell.
    12/12/10 is the following Tuesday. Enter that just below the first one.
    Now highlight both cells, grab the lower right corner and drag down as far as you want.
    Excel will take that 7 day interval and fill in the dates to eternity if you want it to.
     

Share This Page