How can i show today's date using IF formula

[rockingstar]

IF 'A1' is 0 then i want to display today's date in 'B2'
what formula i can use??
pls help..
Thank you

 

[gaz_chops]

Welcome to the forum.

Try this entered in B2

=if(a1=0,today(),"")

You don't say what to do if A1 is not 0, so "" will make B2 blank.

 

[rockingstar]

Thanks for reply,
I tried that formula but i'am getting some strange answer. I'am getting '42225' as result in B2.

 

[My Aswer Is This]

Try this:
Put this formula in B2
If A1 is Empty:
=IF(A1="",TODAY(),"")
If A1 is Zero
=IF(A1="0",TODAY(),"")

You need to set the formatting of B2 to "Date"

 

[rockingstar]

Ohh..Ok Thanks a lot, i got it..

 

[gaz_chops]

Thanks for reply,I tried that formula but i'am getting some strange answer. I'am getting '42225' as result in B2.

42225 is today as a number, format as a date and it will display correctly.

Excel treats dates as a value counting from 1/1/1900 which = 1.