November 10, 2011

How to show expired date in excel


Problem: What is formulae in excel for showing expired dates

Explained for Excel 2003 - 2011:
http://www.techonthenet.com/excel/questions/cond_format4_2007.php

Update:
formulae won't work if user used full stop in the date (11.11.2011.)
Find - replace 2011. with 2011 solved that problem (11.11.2011)

No comments: