ISBETWEEN and ISDATE in Google Sheets
Excel is missing some functions, but Google has ISBETWEEN which compares a value to a low & high in a list or returns TRUE if a specified date is in a target date range (with start and end dates specified). Google also has ISURL and ISEMAIL which test if they have a valid syntax and my favourite is ISDATE which tests if a number is formatted as a date AND has a date value.
Example files can be found here: www.xlconsulting-asia.com/youtube-files
00:00 ISBETWEEN
00:53 Excel equivalent AND
01:30 ISBETWEEN with dates
02:03 ISDATE
03:45 ISEMAIL and ISURL