If so, place them in an Excel worksheet with their start date in one cell and end date (which would be the current date, I assume) in an adjacent cell. Then insert this formula (where the start dates ...

Learn how to calculate net current assets, or working capital, in Microsoft Excel and how to evaluate the financial health of a company.

After consulting the income statement, the owner determines that their current assets for the year are $150,000, and their current liabilities clock in at $60,000.

If you want to calculate how much time is left until a certain expiry date, you can use the DATEDIF function. This function returns the difference between two dates in terms of days, months, or years.