Having full control over your documents at any moment is essential to alleviate your everyday tasks and enhance your productivity. Achieve any objective with DocHub features for document management and practical PDF file editing. Access, modify and save and integrate your workflows with other protected cloud storage.
DocHub offers you lossless editing, the possibility to use any formatting, and securely eSign papers without having searching for a third-party eSignature alternative. Make the most of the file managing solutions in one place. Check out all DocHub features today with your free profile.
hello in this presentation i want to show you how to create a professional customer complaints record to keep the evidence up to date i will use an star.xlsb file in order to allow running macros and also to keep the file dimension as small possible when its filled with thousands of records per year there are two sheets first with records and second one with suppliers name and info about them you can see the evidence of complaints for each supplier also in a chart in order to have same format for all cell containing date i will use same data validation for all of them from data tab select data validation as you can see and fill according to presentation then copy this cell and paste it to all others next i will show the formulas working with date month formula will return only this value from reference cell next formula will obtain the quarter from previous cell to add q before quarter number i change the cell format as shown this formula will calculate the number of days between cel