DocHub makes it quick and straightforward to take out date in spreadsheet. No need to download any extra application – simply add your spreadsheet to your account, use the simple drag-and-drop interface, and quickly make edits. You can even work on your desktop or mobile device to adjust your document online from any place. That's not all; DocHub is more than just an editor. It's an all-in-one document management solution with form building, eSignature features, and the option to enable others fill out and eSign documents.
Each file you edit you can find in your Documents folder. Create folders and organize records for easier search and access. In addition, DocHub guarantees the security of all its users' information by complying with strict security standards.
hello and welcome to another Excel demo with Rich Kerr in this scenario Iamp;#39;d like to calculate how long an invoice has been open and uh to do that weamp;#39;ll take advantage of the today function in Excel so uh if you want to set up uh some sample dates for yourself for this exercise go right ahead and weamp;#39;ll come back from the break and uh start our formula in column B okay Iamp;#39;ll start with an equal sign and my goal is to figure out uh how long ago was November 13th thatamp;#39;s in essence what weamp;#39;re trying to determine so with our equal sign weamp;#39;ll use the today function and remember that the today function is a function so itamp;#39;s followed by a pair of parentheses I will then subtract the invoice date which is in cell A2 so I have the current date so the today function is reflecting the current date uh minus A2 now often when you perform math with dates in Excel the application makes the assumption that your result should be formatted as
