Microsoft Office Forums - View Single Post - Excel formula from looking the base date and convert into desire result

Thread: Excel formula from looking the base date and convert into desire result

View Single Post

Old

02-17-2013, 03:11 AM

Catalin.B

Catalin.B is offline

Catalin.B uses Windows Vista

Windows Vista Catalin.B uses Office 2010 32bit

Catalin.B uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Catalin.B is on a distinguished road

Default

You can use this formula, copied down as necessary:
=IF(INT(($G$3-F5)/365,25)>=4;"> 4 Years";"> "&INT(($G$3-F5)/365,25)&" Years < "&CEILING(($G$3-F5)/365,25;1)&" Years")

Reply With Quote