Thread: Can the value of a tab be used in a calculation
View Single Post
 
Old 08-24-2025, 02:02 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Yes, what version of Excel are you using?
Edit: Oops, I've just noticed what version you're using.
=DATEDIF(DATEVALUE(TEXTAFTER(CELL("filename"),"]")),NOW(),"D")
Last edited by p45cal; 08-24-2025 at 10:28 AM.
Reply With Quote