1 min readfrom 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

submitted by /u/Brownchoccy
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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