I am using Excel 2007 and windows 7.
I have a sheet that gets its data from another sheet. Both sheets have today's date as part of their file name.
The sheet I am working with Gets its data from another sheet which may or may not be opened.
An example of the data that is put in a cell of the sheet is:

=IF(ISBLANK('C:\Skywarn\[05-04-2018 Emergency Log.xls]FORM'!$B$5),"",'C:\Skywarn\[05-04-2018 Emergency Log.xls]FORM'!$B$5)
This is from a summary sheet which is filled in during the use of the log form. Upon completion of the event, the summary sheet is closed snd sent to various people.

The problem is that I need to update the date, in this case 05-04-2018, automatically.
I hope someone can help.
Thanks for looking at it.