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,…
IF
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…