Excel

You can use the following formula to remove the time from a date with a time in Excel: =TEXT(DATEVALUE(TEXT(A2,”mm/dd/yyyy”)),”mm/dd/yyyy”) This particular formula…

You can use the following formulas to find the point of intersection of two straight lines in Excel: Find the X-Value of…

You can use the following basic syntax to add years to a date in Excel: =DATE(YEAR(A2)+3,MONTH(A2),DAY(A2)) This particular formula adds 3 years…

You can use the following basic syntax to perform a VLOOKUP with an array formula in Excel: =VLOOKUP(E2:E8,A2:C8,3,FALSE) This particular formula will…

Often you may want to sum the values of some dataset in Excel based on quarter. For example, suppose we have the…

You can use the following formulas to calculate the number of weeks between two dates in Excel: Formula 1: Calculate Full Weeks…

You can use the EDATE() function in Excel to quickly add a certain number of months to a date. This formula uses…

Often you may want to filter a chart in Excel to only display a subset of the original data. Fortunately this is…

You can use the following formulas to calculate the number of years between two dates in Excel: Formula 1: Calculate Full Years…

You can use one of the following formulas to get the first day of the month for a date in Excel: Formula…