Thread: Can the value of a tab be used in a calculation
View Single Post
 
Old 08-25-2025, 03:00 AM
Pablo2000's Avatar
Pablo2000 Pablo2000 is offline Windows 11 Office 2021
Advanced Beginner
  
Join Date: Dec 2023
Posts: 73
Pablo2000 is on a distinguished road
Default
The reason for having a separate date on each tab is these are monthly tabs and I DO NOT want to over write the data of a previous month. I want to keep each monthÂ’s data as is in that year.

I tried =DATEDIF(DATEVALUE(TEXTAFTER(CELL("filename"),"]")),TODAY(),"D") but that is not working

Attached. CELL A15
Attached Files
File Type: xlsx Electric-2025.xlsx (44.8 KB, 7 views)
Reply With Quote