number of weeks for last 3 months

[#1]

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

[maxgro · Accepted solution]

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

[#3]

Thank You Grossi.