Login Page - Create Account

Support Board


Date/Time: Fri, 27 Sep 2024 03:53:10 +0000



Post From: simple alert help

[2013-11-25 01:43:02]
Sawtooth - Posts: 4092
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