dear,
first attach a sample as requested AliGW

what i understand is you ....
* have daily sales
* monthly targets
* calc monthly sales
* compare MTD sales vs month target
* compare YTD sales vs YTD targets

???

plz dont forget to attach sample file with your answer.