Results 1 to 7 of 7

Need one cell to reference just the month from another date-formatted cell

Threaded View

  1. #1
    Registered User
    Join Date
    11-11-2009
    Location
    Washington, DC
    MS-Off Ver
    Excel 2007
    Posts
    19

    Need one cell to reference just the month from another date-formatted cell

    I'm trying to link two different budgets into a third spreadsheet. The final step I'm attempting to accomplish is have an if-and statement reference just the month from a date-formatted cell. One of my departments tracks their budget on a daily basis, i.e. 11/2/2009, 11/3/2009, etc. rather than just 11/2009. I want the if-and statement to return the budget from all days in a given month so i can apply the formula to the whole year, broken down monthly too. I saw a question similar to this one but didn't see any responses so I'm not sure if it can be done. Thanks for the help!
    Last edited by Runnit4; 11-11-2009 at 06:55 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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