kengooch
Member
- Local time
- Today, 15:58
- Joined
- Feb 29, 2012
- Messages
- 137
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.
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.