Skip to Content
0
Feb 12, 2016 at 10:10 AM

Macro function to calculate the no of days till to date in the planning book.

216 Views

Dear Experts:

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.

Warm Regards

Yadagiri