## Excel 2016 – How to select smallest of multiple dates

The following examples show how to use an Excel formula to select the smallest date from a table. This may be useful where you have a table with duplicate information,…

## Excel – How to calculate the difference between two dates

The following formulas show how to calculate the difference between two dates. The difference can be measured by: days months years days - ignoring years days - ignoring months and…

## Crystal Reports – How to convert text date to datetime format

Text of dates in Crystal Reports can be annoying - you can't apply any date-specific formatting or use the date in formulas - because it is after all, just the…

## Crystal Reports – How to calculate financial year from date

The following code shows how to calculate the financial year from a date in a Crystal Reports. It uses the Australian financial year which is from July to June, e.g.…

## Excel 2016 – How to calculate age from date of birth

The following formulas show how to calculate current age from a date of birth. Calculate age in years This formula will calculate the current age in full years - for…

## Crystal Reports – How to apply alternative line shading

The following steps show how to make the 'details' row in a crystal report using alternative line shading. In this example we will be using a light grey colour (RGB…

## Crystal Reports – How to fix ‘Division by zero’ error

Problem When running a Crystal Report you receive the following error message Division by zero. Solution Before describing how to work around this issue a quick explanation. When you see…

## Excel 2013 – Formula to count unique numbers in column

The following formula will count unique numbers in a column - it does not count text. =SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1))

## How to set default SELECT OPTION using jQuery/JavaScript

I recently needed to set a default option for a SELECT drop down list. As you probably already know, select elements do not support a default value, but you can…