For this purpose the data analysis software IDEA provides functions and also formulas. Formulas are a really helpful tool (like in Excel or other well known analysis tools) to better understand the dataset in front of you. The formulas focussing on date information are plenty in IDEA. One is more needed than the other. Therefore in this blogpost I will present the three most important date functions, that I use constantly in IDEA fraud reviews and audits.