Operations in Excel
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...
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
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...
Excel
Excel: How to Calculate Years Between Two Dates
You can use the following formulas to calculate the number of years between two dates in Excel:
Formula 1: Calculate Full Years Between Two Dates
=INT(YEARFRAC(A2,B2))
Formula...
Excel
How to Get First Day of Month in Excel (With Examples)
You can use one of the following formulas to get the first day of the month for a date in Excel:
Formula 1: Use DAY()...
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