Excel
How to Remove Time from Date in Excel (With Example)
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 will remove the time...
Excel
How to Find the Intersection of Two Lines in Excel
You can use the following formulas to find the point of intersection of two straight lines in Excel:
Find the X-Value of Intersection:
=(INTERCEPT(y2,x2)-INTERCEPT(y1,x1))/(SLOPE(y1,x1)-SLOPE(y2,x2))
This formula assumes...
Excel
How to Add Years to Date in Excel (With Examples)
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 to the date in...
Excel
How to Use an Array Formula with VLOOKUP in Excel
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 return the values in...
Descriptive Statistics in Excel
How to Sum by Quarter in Excel (Step-by-Step Example)
Often you may want to sum the values of some dataset in Excel based on quarter.
For example, suppose we have the following dataset and...
Excel
Excel: Calculate the Number of Weeks Between Dates
You can use the following formulas to calculate the number of weeks between two dates in Excel:
Formula 1: Calculate Full Weeks Between Two Dates
=INT((B2-A2)/7)
Formula...
Excel
How to Add Months to Date in Excel (With Examples)
You can use the EDATE() function in Excel to quickly add a certain number of months to a date.
This formula uses the following basic...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read