Consulting

Results 1 to 4 of 4

Thread: If dates match then add

  1. #1
    VBAX Master
    Joined
    Jun 2006
    Posts
    1,091
    Location

    If dates match then add

    I need to do a really complicated formula that compares two dates and then if the date matches than it needs to add it. That is not the hard part. The hard part is that it needs to keep comparing dates in a column and only add if it matches. In the file I sent what it needs to do is compare the dates in the itemized Misc. Expenses Column and if they match the dates that show up above the days in the week than add it below the day. So basically they can itemize and Mondays expenses and Tuesdays will be filled in for them. If you look at what I sent it will be easier to understand.
    Thank You,
    Daniel Blois
    http://studenthacker.blogspot.com/

  2. #2
    Moderator VBAX Master georgiboy's Avatar
    Joined
    Mar 2008
    Location
    Kent, England
    Posts
    1,198
    Location
    Like this...
    Click here for a guide on how to add code tags
    Click here for a guide on how to mark a thread as solved
    Click here for a guide on how to upload a file with your post

    Excel 365, Version 2403, Build 17425.20146

  3. #3
    VBAX Master
    Joined
    Jun 2006
    Posts
    1,091
    Location
    That was exactly what I wanted. Easier than I thought. What would I do if I had to match too cells. Example I want to do the same thing with meals. So i put in cells with meal name. I want to add to the appropriate cell if the date matches the top again and if the meal name matches the names on the right. Is this possible?
    Thank You,
    Daniel Blois
    http://studenthacker.blogspot.com/

  4. #4
    Moderator VBAX Master georgiboy's Avatar
    Joined
    Mar 2008
    Location
    Kent, England
    Posts
    1,198
    Location
    Like this...
    Click here for a guide on how to add code tags
    Click here for a guide on how to mark a thread as solved
    Click here for a guide on how to upload a file with your post

    Excel 365, Version 2403, Build 17425.20146

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •