Results 1 to 7 of 7

[Additional Question]Formulas for assign monthly values to correspond weeks

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-07-2013
    Location
    US
    MS-Off Ver
    Excel 365
    Posts
    485

    [Additional Question]Formulas for assign monthly values to correspond weeks

    Hello,
    I have a worksheet that requires 3 formulas.
    In row 1, I have the monthly set up. In row 11, I have the weekly set up while Monday is being the first day of the week.

    Formula #1 for rent:
    In row 3, I have the rent payments; each is due on the first day of the month.
    I need a formula in row 13 that will put the monthly rent payment (row #3) to correspond week (first day of the month)

    Formula #2 for Insurance:
    In row 4, I have the Insurance payments; each is due on the last day of the month.
    I need a formula in row 19 that will put the monthly insurance payment (row #4) to correspond week (last day of the month)

    Formula #3 for Bank Interest:
    In row 5, I have the Bank Interest payments; each is due on the 19th of each month.
    I need a formula in row 25 that will put the monthly interest payment (row #5) to correspond week (19th of each month)

    Monthly Payement.xlsx
    I hope I have made myself clear.
    Thanks in advance for all of your great help.
    Last edited by jackson_hollon; 10-07-2014 at 05:57 PM. Reason: [SOLVED]

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find weeks between multiple dates, and correspond with a cell.
    By bellyb in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-11-2013, 08:47 AM
  2. Dividing monthly values into weeks automatically (some months have 5 weeks)
    By massimoo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-07-2012, 03:20 AM
  3. Replies: 2
    Last Post: 06-25-2012, 02:10 PM
  4. Making cell values correspond with Drop down List values
    By jrcream in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2008, 03:14 AM
  5. Replies: 1
    Last Post: 07-11-2008, 05:57 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