News

Set Current Date in Excel The easiest way to add the current date in Excel is to simply type the date. For instance, typing "2018-07-31" in a cell is automatically detected as a date.
How can I add or subtract months from a date using the EDATE function in Excel? To use the EDATE function you will need the starting date and the number of months to add or subtract.
It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.
How to Auto-Format the Date in MS Excel. When you create Microsoft Excel spreadsheets that contain one or more columns of dates, you can make things a bit easier if you pre-format your cells to ...
Microsoft is testing out a new =COPILOT function in Excel cells – it's in beta with improvements needed, but you can try it now.
How to add a monthly balance in Excel As you’ve seen, a daily balance requires only a simple IF () function to match dates before returning the balance for each day.
Excel offers several easy ways to calculate expiry dates. This post explores different ways to automate expiry date calculations in Excel.
One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.