Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can we get the number of weeks in the last 3 months i.e. Dec 2014, Jan 2015, Feb 2015 for till date?
As manually i counted that we have 11 weeks total. Can we get this using expression in script load ?
Please share your experience on this.
Thanks in advance
maybe the number of day between today and the start of 2 months ago, divide by 7 (1 week)
=DIV(today() - MonthStart(addmonths(today(),-2)),7)+1
maybe the number of day between today and the start of 2 months ago, divide by 7 (1 week)
=DIV(today() - MonthStart(addmonths(today(),-2)),7)+1
Thank You Grossi.