can you do this with dates in date studio??
Question is how to calculate the % of the month gone and % remaining
Eg today is the 12th may So it needs to know that may has 31 days And today is the 12th
With Adwords we normally report on last full day So I need a formula that identifies the month. The number is days in that month. The current day And divides those
Reason being for budget calculations
Eg spent 1100 so far. So likely to spend 3100 this month