You all must have watched movie based on War. One thing you all might have noticed, in most of the movies, armies fought with their enemies hiding inside the bunkers, an army fighting war in open obviously...
Purpose:
This function calculates difference between two dates. it can show the result in days, months and years.
Syntax:
=datedif(start_date,end_date,"unit")
start_date
This is earliest...
Situation: You are part of the Finance Team, and work at Headquarters of an Organization.Periodically, You receive expense data from Teams in different Regions.After You receive expense data, You SUM all...
1. Vlookup is not case-sensitive
2. If Lookup value has duplicates in the lookup column, then it returns 1st found value
3. Vlookup cannot pull values which are on the left side from Lookup column
4....
Fill dates Automatically in worksheet cells.
The 1st and 2nd Format are known by Most Excel Users, however, 3rd - 5th Formats are lesser known.
3rd format - Only Weekdays
4th format - Only Months*
5th...