New Contributor

# Number of days depending on period time frame and contract time frame

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

2 Replies

# Re: Number of days depending on period time frame and contract time frame

@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:

# Re: Number of days depending on period time frame and contract time frame

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!