Cell Formula

Hello,

I am making a budget and need to make this formula: =”Variance “&YEAR(A1-300)&”a vs. “&YEAR(A1)&”b”

Show this in a cell: 

Variance 2016 vs. 2017

Right now it shows this:

Variance 2016a vs. 2016b

 

Based on a cell showing date: 12/31/2016

 

 

By: Roy

Leave a Reply

Your email address will not be published. Required fields are marked *