+ Reply to Thread
Results 1 to 4 of 4

calculate no. of days if every month has 30 days

  1. #1
    Forum Contributor
    Join Date
    12-03-2014
    Location
    India
    MS-Off Ver
    2016 .......
    Posts
    393

    Lightbulb calculate no. of days if every month has 30 days

    Hi all
    Please find attachment for kind perusal.

    I have received interest at regular intervals i.e. after every 6 months...
    while calculating the days for interest every month have 30 days.

    If Upto date is > Interest date 2 then days must be calculate from Interest date 1
    else interest date 2 has to be consider for no. of days calculation..

    I require calculation of no. of days in col D on the basis of interest date 1 (col A) & interest date 2 (col B) till upto date (col G)

    thanks in advance
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-07-2021
    Location
    Manama, Bahrain
    MS-Off Ver
    2016
    Posts
    61

    Re: calculate no. of days if every month has 30 days

    try this formula and see if it suits your needs and let us know.

    =+IF($H$1>B2,(DATEDIF(B2,$H$1,"MD")+1)+(DATEDIF(B2,$H$1,"M")*30),(DATEDIF(A2,$H$1,"MD")+1)+(DATEDIF(A2,$H$1,"M")*30))

    H1 has the up to date value. attached the file with the formula for your ease.
    Attached Files Attached Files
    Give a sec to give rep to all who tried to help

  3. #3
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,222

    Re: calculate no. of days if every month has 30 days

    Please try at D2

    =YEARFRAC(IF(B2>$G$1,A2,B2),$G$1)*360+1
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    12-03-2014
    Location
    India
    MS-Off Ver
    2016 .......
    Posts
    393

    Re: calculate no. of days if every month has 30 days

    Thank so much

+ 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. [SOLVED] Need formula to calculate days used in month initiated in previous and selected month
    By Ochimus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-14-2021, 05:54 AM
  2. Replies: 13
    Last Post: 08-09-2020, 04:53 PM
  3. Replies: 2
    Last Post: 04-20-2020, 01:30 PM
  4. [SOLVED] Formula to calculate working days and calendar days per month-year ?
    By donny007 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-05-2018, 06:23 PM
  5. [SOLVED] Calculate Uptime in Days within the constraint of Total Days in Each Month
    By jchungerford in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 04-29-2017, 06:54 PM
  6. [SOLVED] calculate total number of days between two days based on 365 days year
    By aparunkumar in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-14-2016, 12:51 AM
  7. How to calculate end of month -2 days
    By joao1232 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-21-2016, 08:49 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