Feb 10 2022 04:25 PM
Hi,
I want to display the number of days for an interest calculation. I also want the formula to take into account the contract start and end dates as sometimes the quarter has a contract either starting or ending mid way, the contract may not have started or may be ended before or after the quarter so then the # of days should be nil. The formula will need to consider each of the options and decide the correct number of days to accrue the interest.
Examples of the correct values
Feb 10 2022 05:05 PM
@KT123530 This would give you the numbers you're asking for:
But, I don't think it's quite right - I would think the third and fourth entries should be 59 and 56 days (2/1/22-3/31/22 and 2/1/22-3/28/22).
If that's correct, then perhaps this is what you want:
Feb 10 2022 05:17 PM
Thank you very much - this has stumped me for a while and i keep having to do work arounds. A lot simpler than I anticipated!