Results 1 to 5 of 5

Set a month as range based on single date in one cell

Threaded View

  1. #1
    Registered User
    Join Date
    04-04-2011
    Location
    New Jersey, US
    MS-Off Ver
    2010
    Posts
    18

    Set a month as range based on single date in one cell

    I have dates in a row formatted as month/year, i.e. April 2011(4/1/2011). I need a cell under this date to match the April 2011 date to the same month and year in a column on another sheet that has daily dates and select that whole month (April) as the range. Once that range it selected I need it to find a maximum value from the column 2 to the right. Thanks in advance for any help, Mike
    Last edited by mexcel300; 05-13-2011 at 04:31 PM.

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