Also, I need to calculate the age of a person and I use =datedif(xx,xx,"y"). But, again,. the calculation won't work for any date prior to 1900. Is there a fix for both the formatting issue and the calculation? Thanks in advance for your help. Reply Alexander Trifuntov (Ableb...
Note: The DATEDIF function doesn’t count the running month. Read More: How to Calculate Time Difference in Excel Between Two Dates Method 2 – Using YEARFRAC along with INT or ROUNDUP Functions Steps: Enter the following formula in cell D5: =INT(YEARFRAC(B5,C5)*12) The YEARFRAC function...
Let’s do the same thing that was done in example 2 but here instead of calculating months, we will calculate years. We will have new columns namedReceived DateandStored Time (Year). Steps: Enter this formula in cellF4. =DATEDIF(E4,TODAY(),"y") Copy it down toF11. You will get t...