+ Reply to Thread
Results 1 to 4 of 4

Formula to calculate cash out by weeks

Hybrid View

  1. #1
    Registered User
    Join Date
    03-31-2025
    Location
    London
    MS-Off Ver
    365
    Posts
    2

    Formula to calculate cash out by weeks

    Good morning

    I am looking for some help to create a formula.
    The formula needs to produce a value in row 9 which corresponds to the week commencing date above in row 8. For example the value in c4 will be paid 7/3/25 (21/1/25 valuation date(cell c1) + 45 days (b4) = 7/3/25 so would go into cell c9. Value in c5 would be paid 12/3/25 (21/1/25 + 50 days (cell b5) = 12/3 so would go into c9 as falls in that week. Value in c6 would be paid 22/3/25 so would go into cell e9 (21/1/25(cell c2) + 60 days(cell b6) = 22/3/25.

    Many thanks in advance for your help.

    Dan
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2504
    Posts
    19,098

    Re: Formula to calculate cash out by weeks

    Hello Dbbfes and Welcome to Excel Forum.
    I feel that you were on to a possible solution when you calculated the dates in cells C18:C19. Picking it up from there you could use the following: =SUM(C$1,$B4)
    The formula to place the amounts in rows 9 and 13 could then be: =SUMPRODUCT(($C$18:$N$20>=C8)*($C$18:$N$20<SUM(C8,7)),$C$4:$N$6)
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    03-31-2025
    Location
    London
    MS-Off Ver
    365
    Posts
    2

    Thumbs up Re: Formula to calculate cash out by weeks

    Hi JeteMc

    Thank you for the welcome, and a bigger thank you for the formula.

    Has worked perfectly for what was needed.

    Much appreciated

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2504
    Posts
    19,098

    Re: Formula to calculate cash out by weeks

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to Calculate Tasks for the Weeks
    By GemBox in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-08-2022, 02:32 AM
  2. Formula to calculate Fridays date two weeks ago
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-29-2022, 12:18 PM
  3. [SOLVED] Need formula to calculate difference in weeks and days
    By leobuzz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-27-2018, 06:57 AM
  4. Formula to calculate how much stock in weeks
    By JamesR12 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-20-2017, 01:13 PM
  5. Replies: 2
    Last Post: 09-16-2012, 01:58 PM
  6. formula that can calculate 3 weeks from a date given
    By Zyphon in forum Excel General
    Replies: 2
    Last Post: 04-26-2007, 02:30 AM
  7. [SOLVED] Excel formula to calculate % gain when adding cash equity to accou
    By Anita in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-29-2006, 11:25 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