Excel functions in plain English

Returns the end of an offset month.

Counts working days between dates.

Returns a date offset by working days.

Returns the day-of-week number.

Checks whether a reference is blank.

Checks whether a value is numeric.

Checks whether a value is text.

Checks whether a value is an error.

Checks whether a cell contains a formula.

Converts between measurement units.

Calculates a periodic loan payment.

Calculates future value.

Calculates present value.

Calculates net present value of periodic cash flows.

Calculates internal rate of return.

Returns historical data for a financial instrument.

Displays an image from a URL in supported versions.

Groups and aggregates data by row fields in supported Microsoft 365 versions.

Groups and aggregates data by row and column fields in supported Microsoft 365 versions.

Applies a LAMBDA to each value in an array.