IF Then TODAY's Date DD/MM/YYYY

[shawnnewsome]

Hi there,
I'm wanting a formula where IF A1=Text, then return todays date but in a format as DD/MM/YYYY, IF A1 is blank, then return blank. Is this even possible? I'm trying to not have to format the column.

 

[Fluff]

Hi & welcome to MrExcel.
If you want the cell as a real date then you will need to format the cell.

 

[rakesh seebaruth]

=IF(A1="Text",TEXT(TODAY(),"DD/MM/YYYY"),"")

 

[Fluff]

Which will not return today's date, just a text value.

 

[MARK858]

@shawnnewsome Do you mean if A1 is specifically text rather than a number or do you mean if A1 isn't blank? you have asked for both or do you actually mean you want both conditions?

As Fluff has stated the result will be text not a real date.

 

[rakesh seebaruth]

You're correct, my apologies for the mistake. To return today's date that will change automatically as the date changes,

 

[rakesh seebaruth]

we can use the formula =IF(A1="Text",TODAY(),IF(A1="","","Invalid")). This formula checks if the value in cell A1 is equal to "Text". If it is, the formula returns today's date using the TODAY function. If A1 is blank, the formula returns an empty string. If A1 contains a value other than "Text" or blank, the formula returns "Invalid".

 

[shawnnewsome]

10-4. Thanks for the responses! I was hoping there was a way to adjust without formatting.. Back to the drawing board

 

[Fluff]

Glad we could help & thanks for the feedback