Yes, G is the expected outcome.

What I would like to do if possible is to have a formula that would see January 1, 2010 to December 31, 2010 as a full year.
IF date in B4:C23 = Full Year, add : ) column E and F. If not blank.

Right now, I can do it by entering “Year” in D, but I must tell it the date and that’s what I trying to avoid.

Thank you for your quick reply