​Learn how to use Microsoft Excel to easily calculate the percentage of a total using simple formulas, whether you have the total in the same row or not. Discover step-by-step…

​This Excel article explains how to use formulas such as DAYS(), TODAY(), and A2 to calculate the number of days until, between, or after specified dates. Learn how to find…

​Learn how to calculate the difference between two dates in Excel using the DATEDIF formula with different units such as days, months, years, days-ignoring years, days-ignoring months and years, months-ignoring…

​Learn how to bulk convert negative or positive numbers in Excel using two methods. Discover the first method that uses a formula to create another set of numbers and the…

Learn how to use the InStr function in Crystal Reports to test if a text field contains specific text, with examples and case sensitivity explanation.

Convert text date to datetime format in Crystal Reports with these two methods - DateValue and cDate. Learn how to convert text date fields into usable date fields for better…

​Learn how to easily calculate the financial year from a date in Crystal Reports using this simple formula. This code works for the Australian financial year starting from July to…

The #DIV/0! error occurs when a formula tries to divide a number by zero. Learn about the cause and solution for this error in Microsoft Excel 2016 with the IFERROR…

Learn how to create named cell references in Excel 2016 with our step-by-step guide. Discover how to use words instead of letters and numbers in your formulas, while adhering to…