answer:You don’t really need an IF function here. Let me introduce you to another one that’s great for use with dates: DATEDIFF, which gives the difference between dates depending on the parameter you select. Use “y”, “m” or “d”. (You might even be able to use “h” for hours, for all I know. Play with that.) =datediff( OLDER date, MOST RECENT date, “m”) When it works, this will give you the difference in months “m” between Old date and New date. You can divide the answer by 12 to get the years and decimal years’ difference. (You could also use the “y” parameter instead of “m” to get “whole years”, but that won’t give you the remainder that you seem to want.) If the function doesn’t work for you at first, or you get a NAME? error, then you’ll need to activate the Add-in that contains this function, which is very simple. Send a follow-up message if you need that assistance.