Web development, programmer engineering and coding website on augmented reality interface screens. developer project engineer programming software or application design, Cartoon vector illustrationExcel
Detailed
=IF(ISBLANK([@Date]), "", IF([@Date]<TODAY(), ((CONCATENATE(DATEDIF([@Date],TODAY(),"y")," y, ", MOD(DATEDIF([@Date],TODAY(),"m"),12), " m, ", MOD(DATEDIF([@Date],TODAY(),"md"),365), " d"))), ((CONCATENATE(DATEDIF(TODAY(),[@Date],"y")," y, ", MOD(DATEDIF(TODAY(),[@Date],"m"),12), " m, ", MOD(DATEDIF(TODAY(),[@Date],"md"),365), " d")))))
Day
=IF(ISBLANK([@Date]), "", IF([@Date]<TODAY(), CONCATENATE(DATEDIF([@Date],TODAY(),"d")," d") , CONCATENATE(DATEDIF(TODAY(),[@Date],"d")," d") ))
Month
=IF(ISBLANK([@Date]), "", IF([@Date]<TODAY(), CONCATENATE(DATEDIF([@Date],TODAY(),"m")," m") , CONCATENATE(DATEDIF(TODAY(),[@Date],"m")," m") ))
Year
=IF(ISBLANK([@Date]), "", IF([@Date]<TODAY(), CONCATENATE(DATEDIF([@Date],TODAY(),"y")," y") , CONCATENATE(DATEDIF(TODAY(),[@Date],"y")," y") ))
Related
