Resources
How to find the last day of a month in Excel
In this article, we are going to show you how to find the last day of a month in Excel. We...
How to find the position of the minimum value in Excel
You can find the minimum value in a range or array using the MIN, MINA and MINIFS functions. If you need to find the position of the minimum value instead, you will need a combination of these functions. In this article, we are going to show you how to find the...
How to find the position of the maximum value in Excel
Excel has the MAX, MAXA and MAXIFS functions that can find the maximum value in a range or array. If you need to the position of the maximum value, however, you need to combine these formulas with others. In this article, we are going to show you how to find the...
How to enter dates only in the current week in Excel
In this article, we are going to show you how to allow users to enter date values only for the current week in Excel. [button link="https://www.spreadsheetweb.com/wp-content/uploads/2020/12/How-to-enter-dates-in-the-current-week-only-in-Excel.xlsx" type="big"...
How to prevent future dates from being entered in Excel
It can be a challenge to make data entry consistent in concurrent use. A common example is entering a future date into a form. In this article, we are going to show you how to prevent future dates in Excel. [button...
Converter Template
Unit conversion can be tricky, especially when dealing with some scientific units such as velocity, or energy. This Excel template was built to make conversions simple and easy to understand. One of the biggest advantages of using an Excel tool for unit conversion is...
Depreciation Calculator
This is an easy to use depreciation calculator template that can give you the annual depreciation rates and book values using straight-line, double-declining balance, and units of production methods. Simply enter the asset details like the initial value, salvage...
Car Lease vs Purchase
Should you lease or purchase your new dream car? Purchasing a car is a big purchase, and you wouldn't want to rush it! A car is an asset, but they lose value over time. On the other hand, leasing can still provide the benefits of owning a car, but typically at a lower...
Cash Flow Projection
This template can be used for tracking or projecting cash flows of a business or individual over 12 months. A cash flow chart and a Pareto chart are available, pointing the largest 5 expenditures by category. To use the tool, enter the initial cash amount on top-left,...