Easy formula request

[Quinton]

Hello I have the following formula:

=IF(D24="< empty ><EMPTY>",TODAY(),D24)

Rather than showing "todays date" (or the existing result in D24) I would like it to show a specific date such as "20/20/2020"

Any ideas?

Cheers,

 

[VoG]

Try like this

=IF(D24="< empty >",DATE(2020,2,20),D24)

 

[Richard Schollar]

Use the DATE function or coerce a string to the required date:

=IF(D24="< empty >",DATE(2011,7,20),D24)

=IF(D24="< empty >","20 July 2011"+0,D24)

 

[Andrew Poulsom]

There isn't such a date as 20/20/2020, but you can use the DATEVALUE function to return a serial date from a string, eg:

=DATEVALUE("25/12/2011")

 

[Trevor G]

I have done this

Change format of formula cell to date

Excel Workbook
	D	E
24	12/07/2011	20/12/2011
Sheet2