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

1. ## 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)

2. ## 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.

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

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

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

Thank so much

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

#### 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