dear,

i want to make a daily comparison report with last year and current date. can you advice me how can i put formula to get this


example

item name date      today sales     last year sales
xxxxx     06-1-15        25000          27000

kindly advice me how can i get this also i need to get the weekly sales with last year the same week.

Not sure how to get the same week.  You might be able to use the datediff function and and assume a 52 week difference.

As far as difference, once you have established the values, you should be able to subtract them in a formula.