Support Board

Date/Time: Sun, 24 Nov 2024 18:45:43 +0000

Post From: simple alert help

[2013-11-25 01:43:02] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4119
Use the DATEVALUE function: =AND(BARDATE>=DATEVALUE("05/06/2009"),BARDATE<=DATEVALUE("06/06/2009")) http://office.microsoft.com/en-us/excel-help/datevalue-HP005209044.aspx?CTT=5&origin=HP005204211 http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HP005204211.aspx Date Time Of Last Edit: 2013-11-25 01:47:11