Same day YTD and MTD

[nareshthavidishetty]

Hi,

In the attached application we have created YTD and MTD based on dates for ex:MTD 2017 Jan 1st to Jan 31st sales and it is sames for 2016 as well.

Here the user request the mtd for day wise

ex: 1/1/2017(Sunday) vs 1/3/2016(Sunday) sales.

Please find the attached spreadsheet which shows the logic to calculate YTD and MTD

Thanks..

[nareshthavidishetty]

Hi,

Any clue to get this.

Thanks..

[nareshthavidishetty]

Hi ,

I need to create an line chart which needs current year vs last year MTD Daywise.

Please find the attached spreadsheet for referring the dates.

Thanks..