•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How can I create a database to keep my visits and reports organised?
Hey guys, I work for a local authority and my job consists of going out to visit people and then writing reports on them.
The markers I need are
A visit to be completed every 50 days (that gives 6 days grace)
A big document to be completed every 165 days (that gives 15 days grace)
I’m sure there’s an easy formula where I can visually colour coded see when someone is coming up for a visit or a big document that is needed to be updated so I can easily keep track of my reports and visits? Thanks
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#big data management in spreadsheets
#generative AI for data analysis
#big data performance
#rows.com
#AI formula generation techniques
#Excel compatibility
#formula generator
#Excel alternatives
#database
#visits
#reports
#local authority
#document
#markers
#track
#big document
#organisation
#formula