Editing excel is fast and simple using DocHub. Skip downloading software to your computer and make changes with our drag and drop document editor in a few easy steps. DocHub is more than just a PDF editor. Users praise it for its efficiency and powerful features that you can use on desktop and mobile devices. You can annotate documents, create fillable forms, use eSignatures, and deliver documents for completion to other people. All of this, combined with a competitive cost, makes DocHub the ideal decision to inject age in excel files effortlessly.
Make your next tasks even easier by turning your documents into reusable web templates. Don't worry about the security of your data, as we securely keep them in the DocHub cloud.
hello and welcome back to tips and times Savers Iamp;#39;m Danny rocks in my previous lesson I demonstrated how to use a pivot table to summarize data by the hour now quite a few viewers contacted me to find out what other types of summary we can use with the pivot table one viewer in particular was interested in finding out how to group the uh samples in his test by age bracket itamp;#39;s really fairly simple to do first off while our uh testers gave us our birthday and we notated whether they were male or female somehow or another we forgot to add in the age now I like to use the date diff function to quickly calculate the difference between two dates their birth date and the current date so the date diff function is an undocumented function in Excel so you wonamp;#39;t find it in any of the drop down a list of functions so date Di and then a left parenthesis now the first argument is the starting date in other words the early date comma and then we want to find the later date no