This content has been marked as final.
Show 6 replies
-
1. Re: Comparing Current month data with previous year's month data
Deepak Rai Jul 31, 2017 3:30 PM (in response to Rupali jain)IF Year(data Loaded)=Year(Today())-1 and month(dataloaded)=Month(Today()) Then True else false end.
Won't this work?
-
2. Re: Comparing Current month data with previous year's month data
Rupali jain Jul 31, 2017 3:38 PM (in response to Deepak Rai)Hi Deepak,
Thank you for replying. This formula doesn't help. If I add this my worksheet becomes blank.
Thank you
-
3. Re: Comparing Current month data with previous year's month data
Deepak Rai Jul 31, 2017 4:02 PM (in response to Rupali jain)Put This in Rows
IF MONTH([Dataloaded]) = MONTH(TODAY())
AND DAY([Dataloaded]) <= DAY(TODAY())
THEN [Sales]
END
Drag Year (dataloaded) to Columns and Filter for 2017 and 2016 only.
Thanks
Deepak
-
4. Re: Comparing Current month data with previous year's month data
Rupali jain Jul 31, 2017 4:25 PM (in response to Deepak Rai)it doesn't work!
-
5. Re: Comparing Current month data with previous year's month data
Deepak Rai Jul 31, 2017 4:36 PM (in response to Rupali jain) -
6. Re: Comparing Current month data with previous year's month data
Deepak Rai Jul 31, 2017 4:38 PM (in response to Rupali jain)