Check Box True return Today's date

[AJWildOne]

I added a check box in Excel that returns "TRUE", "FALSE" in cell D38 Then added this formula =IF(D38="TRUE",TODAY())
to D34 where I want today's day to display if the checkbox is "True".

Seems simple and would be very usefull but it doesn't work. Any suggestions for syntax?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(D38=TRUE,TODAY(),"")

 

[AJWildOne]

Hi & welcome to MrExcel.
How about

=IF(D38=TRUE,TODAY(),"")

I knew it was simple... I am new to this. Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.