Problems with CELL("filename") when using multiple workbooks

[kengooch]

We collect data on patient transfer in a worksheet name 2022-11-01 Patient Transfer one sheet for each day. We use the CELL("filename") function to read the file name and parse off the date from the file name. From that date we calculate How many days spent in the hospital. We did this because if we use the Today() function, then when you open an existing sheet, it changes the date on the sheet and then the Days spent in the hospital is not correct.

If we have multiple days open, evaluating transfers on these days and the sheet recalculates, it changes the date for all open workbooks to the filename of the active sheet. I need some way (other than vba which doesn't seem to work in Share Point) to set a sheet date automatically that won't change when the sheet is opened in the future.

 

[The_Doc_Man]

Perhaps define with an IIF such that if the cell is blank then use TODAY() otherwise do nothing?

 

[arnelgp]

to set a sheet date automatically that won't change when the sheet is opened in the future.

no guarantee (non-vba) that you will find one.
mistakenly striking a key will trigger that the workbook has been "modified".