Forum Discussion

Copper Contributor

Sep 08, 2020

Automatic Date Update (No Interaction)

We have a file I wish to have displayed on a TV 24/7 in which a counter shows how many days since an event last occurred. The only time interaction with the file would occur would be to update the la...

excel

Formulas and Functions

ldcox8551

Copper Contributor

Sep 08, 2020

Craig Hatmaker

Worked perfectly. Thank you very much. I've never used Query before and you made it very easy to figure out.

Craig Hatmaker

Iron Contributor

Sep 08, 2020

ldcox8551Glad it worked for you. BTW - I like Bennadeau's solution. If you need updates quicker than 1 minute, use it. If not, my PQ approach does not require VBA. I love VBA, but then, I'm a coder and not everyone is. VBA can also trigger security alerts.