Lets see the below generic if formula with greater than operator.

How to use text formula in excel for date. Sometimes people may give the date in the format like 10022019 which they mean 10022019. For this we can use the formula. TEXT A1.

The point is that other Excel date functions not always can recognize dates entered in the text format. Combining the text given with data using TEXT function. The DATE function is useful for assembling dates that need to change dynamically based on other inputs in a worksheet.

Enter a date in cell A1. Note that Excel rounds the value to 2 decimal places. Now if we try to combine todays date using CONCATENATE Excel would give a weird result as shown below.

Examples for text. Ddd dd mmm yyyy Youll immediately see where the problem at hand lies. Observe the formula in the above screenshot.

In your example TODAY already a real date and not a date stored as text so doesnt make too much sense to use DATEVALUE there. Here are some example dates and how CELL recognize them. Format value output ddmmmmyyyy 12June2015 D1 ddmmyyyy 12062015 D1 yyyy 2015 G.

For example with 2018 in cell A1 the formula below returns the date April 15 2018. The date is TEXTB4dddd mmmm yyyy. The formula only works if your device language is set to English.