Year on Year - YTD Values....
I have a sheet that includes sales data for the last five years. What I want to achieve is to have a formula that calculates a separate YTD Sales figure for Last Year (YTD) and This Year (YTD) based on a specific date i.e. today's date for This Year(YTD) and a comparable (calculated date) for Last Year (YTD).
Is this even possible?
Thanks in advance for all help.
Help Article Resources
Check out the Formula Handbook template!