Month To Date Customised

[#1]

Hello!

I want to create a MonthToDate report that can show me the turnover like that:

day 1   day 2  .............. day 31  monthtodate(the sum of the other days) ....etc

How can i calculate the turnover for each day of the month and not lower the program's functionality with all the calculus implied? I have to mention that i have other objects on the sheet, and the formulas will be recalculated with every selection i make.

Thanks!

[orital81]

No, in the 3rd and the 4th columns.

try to disable the first column, since it can have conflict with last year MTD.

You can just set it as Today().

[#3]

For the 3rd and the 4th columns, i used inMonthToDate() function, and it worked just fine before adding the first column. Isn't ok if i leave those columns unaltered? I mean, can't i just change the first column to fit the others or do i have to adapt the others too?

[#4]

Hi Ori

excellent work this has helped me out alot, however I'm trying to modify it to calculate the YTD for a variable year and always using Today() date i.e. Month, day and year selected.

any help would be appreciated.

Thanks

David