Whether you are already used to working with spreadsheet or handling this format the very first time, editing it should not feel like a challenge. Different formats may require particular apps to open and modify them properly. However, if you have to swiftly black out age in spreadsheet as a part of your usual process, it is advisable to find a document multitool that allows for all types of such operations without the need of additional effort.
Try DocHub for streamlined editing of spreadsheet and also other document formats. Our platform offers straightforward papers processing regardless of how much or little previous experience you have. With all tools you need to work in any format, you will not have to switch between editing windows when working with each of your documents. Effortlessly create, edit, annotate and share your documents to save time on minor editing tasks. You’ll just need to register a new DocHub account, and you can begin your work instantly.
See an improvement in document management efficiency with DocHub’s straightforward feature set. Edit any document quickly and easily, regardless of its format. Enjoy all the benefits that come from our platform’s simplicity and convenience.
all right in this video Im gonna show you how to calculate age and years of service when you have a date so in this case lets start with age so lets say we have the birthday for a list of people wed like to calculate the age of that person so Im gonna type age lets make this the same format by using the format painter now this is the date I have on the left so what Im gonna have to do Im gonna do equal sign and use a function called date diff now if youre an Excel user this function is still available you will probably not see populate like this so its not one of the documented functions but its still available so if you type the function it will still work so Im gonna do date death and this function accepts a start date and an end date and the format so the start date in this case is gonna be the birthday comma and the end date its gonna be whatever the end date is so if I wanted to do todays date I could put it in quotes so Im gonna do 7 10 20 19 something like that c