Need help in displaying the date for data in a cell

[thedoge1]

I have created a dashboard with 7 cells to show the data by hour for each of the previous 7 days.  I want to show the date for the data that is being displayed in each cell.  The expression that I am using does display the correct date but it also shows an error message along with the date.  Below is the expression and a picture of what the cell looks like.  I would also like to show the date in the mm/dd/yyyy format rather than how it is currently being displayed in the cell.  Any help would be appreciated.

=Date={"$(=Date(Today()-7,'DD/MM/YYYY'))"}

[NitinK7]

my be

='Date=' & Date(Today()-7,'DD/MM/YYYY')

[thedoge1]

Thanks for the help.  This does display the correct date but it is showing in the below format.  How would I eliminate the "Date =" portion and display just the date?

[avinashelite]

Just use this Date(Today()-7,'DD/MM/YYYY') 

[thedoge1]

That did it. Thank  you.

[avinashelite]

Then please mark the thread as answered and help to close this thread