Excel DATEDIF function

preview_player
Показать описание
Using the secret DATEDIF function in #Excel to determine how many years, months or days are between 2 dates.

Click here to download a comparison guide cheat sheet that lists out the differences between Simple Start, Essentials, Plus and Advanced subscriptions.

Disclaimer - I offer affiliate links. This may result in commissions being paid to me by 3rd parties which will have no impact on the purchaser.
Рекомендации по теме
Комментарии
Автор

I have a spreadsheet whereby I want each year to become a darker color then anything plus3 years to be the darkest, I just can not get my head around the formula.

joseph
Автор

The formula you typed contains an error.

rimba
Автор

WHAT ABOUT WEEKS IT WAS GIVING ERROR #NUM!

bhupinderbirdi
Автор

I'm using Excel 16, and it shows another date, rather than a single number.

BigClaytoFan