by John MacDougall | May 9, 2016 | Date and Time
This function will take a date in any format and return the day as an integer from 1 to 31. Numbers not formatted as a date will return a day value as long as the number is in the range 1 to 2,958,465 as this corresponds to the date range 01/01/1900 to 31/12/9999.... by John MacDougall | May 9, 2016 | Date and Time
This function will take a date in any format and return the month as an integer from 1 to 12. Numbers not formatted as a date will return a month value as long as the number is in the range 1 to 2,958,465 as this corresponds to the date range 01/01/1900 to 31/12/9999.... by John MacDougall | May 9, 2016 | Date and Time
This function will take a date in any format and return the year as an integer from 1900 to 9999. Numbers not formatted as a date will return a year value as long as the number is in the range 1 to 2,958,465 as this corresponds to the date range 01/01/1900 to... by John MacDougall | May 9, 2016 | Information
This function allows you to test an expression and returns TRUE if your given expression results in any error apart from #N/A. For this function the #DIV/0, #NAME, #NULL!, #NUM!, #REF!, or #VALUE! errors all result in TRUE and the #N/A error or any other value results... by John MacDougall | May 8, 2016 | Information
This function allows you to test a expression and returns TRUE if your given expression results in an error (#DIV/0, #N/A, #NAME, #NULL!, #NUM!, #REF!, or #VALUE!) and FALSE otherwise. Syntax ISERROR(Value) Value (required) – This is the...
