Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Show Nth Day of Month

  1. #1
    Join Date
    11th December 2006
    Posts
    2

    Show Nth Day of Month

    I have a daily history of the S&P that I downloaded from Yahoo Finance. I would like to show only the third friday of the month and hide the rest of the days.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,784

  3. #3
    Join Date
    11th December 2006
    Posts
    2

    Re: Show Third Friday

    Quote Originally Posted by Dave Hawley
    http://finance.yahoo.com/q/hp?s=%5EGSPC Here is where the data is from. I would like to keep all data in one workbook and show the third Friday of every month all the way back to 1950. I'm not great with excel and would app any help you can give.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Show Third Friday

    =(DATE(YEAR(A1),MONTH(A1),21)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),16),1)+1)

    where A1 houses your date.

    HTH

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Show Only Month Name In Date Cells
    By kategorgeous in forum Excel General
    Replies: 5
    Last Post: May 22nd, 2008, 20:48
  2. Date To Show As Month
    By sriya in forum Excel and/or Access Help
    Replies: 3
    Last Post: March 25th, 2008, 11:43
  3. Show Month Of Date Added In Cell
    By kitvel in forum Excel General
    Replies: 3
    Last Post: March 20th, 2008, 17:24
  4. Hide/Show Image By Month
    By Ramaso in forum Excel General
    Replies: 3
    Last Post: September 15th, 2007, 11:38
  5. Increase Date By 1 Month & Return Month Name
    By Macropheliac in forum Excel General
    Replies: 6
    Last Post: October 29th, 2006, 10:08

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
  •  
porno