Cell Formula


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 *