May 1 • General discussion
Found a Function I Wished For
So the other day, I found that Excel has a pretty useful function that isn't listed when you click on the function button. (see pics & try it yourself). It calculates the number of days, months, or years between two dates. (You could do weeks by using days and dividing by 7).
You can also find the number of days between by subtracting two dates.
DATEDIF(Start_Date, End_Date, Interval)
1
0 comments
Found a Function I Wished For
skool.com/excel-analytica
Mentorship community for business analysts to grow their skills in Excel, SQL, & Automation.
Leaderboard (30-day)
1
+1
2
+1
3
+1
Powered by