Microsoft Office Forums - View Single Post - Can the value of a tab be used in a calculation

Thread: Can the value of a tab be used in a calculation

View Single Post

Old

09-02-2025, 09:42 PM

Scott Huish Scott Huish is offline

Scott Huish is offline

Scott Huish uses Windows 11

Windows 11 Scott Huish uses Office 2021

Scott Huish uses Office 2021

Office 2021

Novice

Join Date: Jul 2025

Posts: 9

Scott Huish is on a distinguished road

Default

But assuming the tab was a date, why do you need DATEDIF, why not just subtract them?
=TEXTAFTER(CELL("filename",A1),"]")-TODAY()

Reply With Quote