Results 1 to 5 of 5

Formula for finding the difference between the 1st of month and 1st of another month

Threaded View

  1. #1
    Registered User
    Join Date
    08-07-2013
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2003
    Posts
    22

    Smile Formula for finding the difference between the 1st of month and 1st of another month

    Good Afternoon,

    Need some help with a formula. I want to find the sum of two rows (6 columns) but I need it to search for the 1st of the month of each two months.

    See attached worksheet.

    So if I have a date in cell O2 (01/01/2014) I need a formula that sums the row that contains 01/01/2014 and subtracts it from the sum of the row that contains 02/01/2014.

    I'm using this formula [=(SUM(D35:I35)-SUM(D4:I4))] for the total used in the month but I want it to update month by month. I attempted using [=(SUM(IF(MONTH,DAY(A6:A39)=MONTH(O2),D4:I39)))-(SUM(IF(MONTH,DAY(A6:A39)+1MONTH,DAY(O2),D4:I39)))] but cannot resolve the date issue.

    Thanks,
    Attached Files Attached Files
    Last edited by btoohey44; 01-06-2014 at 08:03 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto instert Month names for This month, Last month and Next month
    By hemal89 in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2013, 12:01 PM
  2. Date Formula for days of the month, new dates starting on the 2nd of the month.
    By Kenn Jerger in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-04-2013, 01:31 AM
  3. Replies: 5
    Last Post: 10-04-2012, 07:06 AM
  4. Replies: 4
    Last Post: 02-14-2010, 05:21 AM
  5. Replies: 3
    Last Post: 09-25-2007, 10:26 AM

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