How to fix NUM error for age calculation in excel

preview_player
Показать описание

This video shows you how to calculate age as year, month, days using datedif formula & how fix #NUM error in MS Excel 2013.

Join this channel to get access to perks:

#excel
#exceltutorial
#learnexcel
Рекомендации по теме
Комментарии
Автор

am getting # number error in dated if 01 January 2020 (A2cell)and 16 march 2021(B2 cell) day (C1 cell)I am using formula
dated if( $A1, $B1, C$1)
and ctrl enter
Answer is #num!
Can you please help me with this error? Iam trying to find number of days by freezing row and column

nareshvarma