Forum

It is not inexplicable. The return includes interest, which is calculated from issue date to maturity. If you move the issue date, then more (or less ...

The interest is calculated from issue to maturity. If you make the issue date earlier, then the portion of interest applicable to the settlement value...

You've misunderstood the date parts. You should add a year for the maturity date, not 360 days. If you check the results of YEARFRAC(B2,B3) for exampl...

Here's one way to do it: =LET(data,A1#,MAKEARRAY(ROWS(data)-1,COLUMNS(data),LAMBDA(r,c,INDEX(data,r,c)=INDEX(data,r+1,c))))

As far as I know, if you use 0 for the number of days, it simply returns the start date, ignoring other settings. It's up to you to ensure that the st...

If it worked before and now it doesn't, the most likely cause would be an update (windows or Office or Power BI, depending on what you are using this ...

You could use something like: =LET(counts,SEARCH(names,A2),TEXTJOIN(",",TRUE,CHOOSECOLS(SORT(FILTER(HSTACK(names,counts),ISNUMBER(counts)),2),1)))

You could try something like this: Sub GetApprovedNames() Dim GivenNamesRange As Range Set GivenNamesRange = Range("G3:G" & Cells(Rows.Cou...

I can't access your file for some reason but, if there is no finish date, how do you calculate the total duration to work out a percentage?

Insert a class module, rename it BankAccount and then paste in this part of the code: Public AccountNumber As Long Public Balance A...

If you have TEXTSPLIT available to you, you can use: =Sum(Sumifs( Sumrange, Criteria Range1, 2022, Criteria Range2, TEXTSPLIT(some cell, ","))...

Apologies - it was not my intention to make you feel bad. I just wanted to point out that there are generally limits to what you'll get from a forum.

You could do something like this?

This is getting close to consultancy work (which I don't do any more) rather than forum Q&A... I can't test this as I don't use shared mai...

Is the signature part of the template? Do you need the code to send one email per person, or simply start a new email for each 500 (or so) add...