Spreadsheet: 845670d1697085558-i-need-help-in-attached-excel-sheet-calculation-of-no-of-days-with-formula-excel-results-required-no-of-days-calculation-etaf
Sheet: Excel Help Required

Security  Code | Maturity Date | Customer Name | CCY | Issue Date | Face Value of Investment | Tenor of INPCs | Profit | No. of | PROFIT JUN 23 | Profit | No. of | PROFIT JUL 23 | Profit | No. of | PROFIT AUG 23 | Profit | No. of | PROFIT Sep 23 | Profit | No. of | PROFIT Oct 23 | TOTAL PROFIT
 |  |  |  |  |  |  |  |  | 2023-06-01 00:00:00 |  |  | 2023-07-01 00:00:00 |  |  | 2023-08-01 00:00:00 |  |  | 2023-09-01 00:00:00 |  |  | 2023-10-01 00:00:00
 |  |  |  |  |  |  | Rate % | Days | 2023-06-30 00:00:00 | Rate % | Days | 2023-07-31 00:00:00 | Rate % | Days | 2023-08-31 00:00:00 | Rate % | Days | 2023-09-30 00:00:00 | Rate % | Days | 2023-10-31 00:00:00
 |  |  |  |  |  |  | 2023-06-01 00:00:00 | 2023-06-01 00:00:00 |  | 2023-07-01 00:00:00 | 2023-07-01 00:00:00 |  | 2023-08-01 00:00:00 | 2023-08-01 00:00:00 |  | 2023-09-01 00:00:00 | 2023-09-01 00:00:00 | 30 | 2023-10-01 00:00:00 | 2023-10-01 00:00:00 | 31 | TO DATE
393100-584 | 2024-06-05 00:00:00 | [NAME] | USD | 2023-06-05 00:00:00 | 5000 | 1-Year | 0.0651 |  |  | 0.0651 |  |  | 0.0649 |  |  | 0.065 |  |  | 0.065
373100-584 | 2023-09-09 00:00:00 | [NAME] | PKR | 2023-06-09 00:00:00 | 300000 | 3-Months | 0.1051 |  |  | 0.1051 |  |  | 0.1051 |  |  | 0.155 |  |  | 0.155
393100-584 | 2023-12-14 00:00:00 | [NAME] | GBP | 2023-06-14 00:00:00 | 5000 | 6-Months | 0.0651 |  |  | 0.0651 |  |  | 0.0649 |  |  | 0.065 |  |  | 0.065
393100-585 | 2026-06-19 00:00:00 | [NAME] | EUR | 2023-06-19 00:00:00 | 9000 | 3-Year | 0.0651 |  |  | 0.0651 |  |  | 0.0649 |  |  | 0.065 |  |  | 0.065
393100-585 | 2028-06-27 00:00:00 | Natasha | USD | 2023-06-27 00:00:00 | 5000 | 5-Year | 0.0651 |  |  | 0.0651 |  |  | 0.0649 |  |  | 0.065 |  |  | 0.065
 |  |  |  |  |  |  | Result req |  |  | Result req |  |  | Result req |  |  | Result req |  |  | Result req
 |  |  |  |  |  |  | Explaning | There are 4 dates
 |  |  |  |  |  | current month start |  |  | fist date of [NAME]
 |  |  |  |  |  | current month end |  |  | last date of [NAME]
 |  |  |  |  |  | start date |  |  | 1st, 30th or 5thJun23, which is between (=5th)
 |  |  |  |  | end date | end date |  |  | 1st, 30th or 5thJun24, which is between (=30th)
 |  |  |  |  |  |  |  |  | 30th-5th+1
 |  |  |  |  |  |  |  | I NEED A FORMULA FOR HAVING NUMBER OF DAYS IN EACH MONTH LIKE IF MONTH AFTER MATURITY IS JULY 31 DAYS, AUGUST 31 DAYS, SEPTEMBER 30 DAYS, …….. AND IN THE MONTH OF MATURITY THE REMAINING NUMBER OF DAYS DURING THAT CERTIFICATE WAS OUTSTANDING.  Other wise profit calculation on each month will be overstated. Also rate of profit in each month is keep on changing. Thus, we need excat number of days on monthly basis to calculate and disburse monthly profit on the basis of new monthly rate. Please see below stuff how we need no. of days month wise with the help of formula.
 |  |  |  |  |  |  |  | 26 |  |  | 31 |  |  | 31 |  |  | 30 |  |  | 31
 |  |  |  |  |  |  |  | 22 |  |  | 31 |  |  | 31 |  |  | 8 |  |  | 0
 |  |  |  |  |  |  |  | 17 |  |  | 31 |  |  | 31 |  |  | 30 |  |  | 31
 |  |  |  |  |  |  |  | 12 |  |  | 31 |  |  | 31 |  |  | 30 |  |  | 31
 |  |  |  |  |  |  |  | 4 |  |  | 31 |  |  | 31 |  |  | 30 |  |  | 31