+ Reply to Thread
Results 1 to 4 of 4

How to calculate the day?

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    272

    How to calculate the day?

    Dear Friends,

    PFA the sample file.

    I tried formulas in col K, L, M, N. But I am not sure of outcome for thousands of rows.
    Wrong output in col, N.

    Could you please assist?
    Attached Files Attached Files
    Last edited by lalaarif1; 04-13-2024 at 10:28 AM. Reason: file updated

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,775

    Re: How to calculate the day?

    Your file is not self-explanatory. If you are getting wrong output, please explain what the right input is and how to determine it from the data you show.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    272

    Re: How to calculate the day?

    Dear 6StringJazzer,

    Our financial year is from 1st Apr 2023 to 31st Mar 2024.

    Col. K : Total month in FY 23-24 for which rent would be charged.

    Col. L : rent for "Existing branches" is charged for all 12 month.
    Col. M : if "New branch" is opened in Jun 23, then 10 months rent would be paid.
    Col N. : if branch lease is expired in Jun 23, then 3 months rent would be paid.

    If branch is opened on 1st Apr 23, then it should come in col M ("New branch")

    So in N11, N18, N22 is showing wrong output. They should be 0.
    Also my check column should be 0.

    Please assist.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,408

    Re: How to calculate the day?

    Try

    for column "N"

    in N6

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Replies: 7
    Last Post: 04-19-2023, 11:53 AM
  2. Replies: 2
    Last Post: 04-17-2023, 02:46 PM
  3. Index Match to calculate data - Filter calculate
    By Tgbell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-03-2019, 01:46 PM
  4. Code to Calculate the product of two matrices won't calculate
    By njrobby in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-05-2015, 01:37 AM
  5. Target.Calculate to Me.Calculate breaks Copy/Paste
    By vayana in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2013, 10:36 AM
  6. [SOLVED] Calculate values in col B based on value in col B but only calculate final 5 instances
    By arnoldd99 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-04-2013, 11:53 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