Hi guys. I'm working on a spreadsheet and I need to be able to calculate how many days something has been opened.
If something doesn't have a closed date I need to use todays date with day it was opened.
Hi guys. I'm working on a spreadsheet and I need to be able to calculate how many days something has been opened.
If something doesn't have a closed date I need to use todays date with day it was opened.
Maybe...
Change cell ranges to suit your needs.Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks