We create forecast in monthly buckets. Our requirement is to calculate the no of days till to date in the current bucket and to get the forecast til to day in the bucket and compare it to actual sales and generate a alert,
I am facing the issue in getting no of days till today in current bucket.
The function WDAYS() get the total no of days in current month and not abel to get the no of days till today in current monthly bucket.
Please let me know how to get the no of days till today in current bucket.
Thanks in advance.