Document editing comes as an element of numerous professions and jobs, which is the reason tools for it must be reachable and unambiguous in their use. An advanced online editor can spare you plenty of headaches and save a considerable amount of time if you have to Spread out age invoice.
DocHub is an excellent demonstration of an instrument you can master very quickly with all the useful functions accessible. You can start editing instantly after creating an account. The user-friendly interface of the editor will allow you to find and utilize any feature right away. Experience the difference with the DocHub editor as soon as you open it to Spread out age invoice.
Being an integral part of workflows, file editing must remain simple. Utilizing DocHub, you can quickly find your way around the editor and make the necessary modifications to your document without a minute wasted.
in this video we will learn the use of logical functions if an we want to locate invoice ages based on the invoice date and the current date so that the difference between the current dates and invoice date is calculated on column D would want to count to the column that contains its age that is between inverse there are below 30 days to inverse there are over 120 days to get started well have the current dates on cell a1 and the current date is equals to today so that this refreshes every day we calculate the number of days passed by subtracting the current dates I lock it with absolute reference minus the inverse dates then and try to get the number of days here once I get the number of days I want to bring in the inverse amount for any invoice that is below that days so Ill use the simple if is equals to if open the bracket if this number of days is less than or equals to 30 then Ill bring in the in with amount otherwise value if false I bring in zero then press ENTER and copy d