Dear All,

I have the following formula in my excel base don the date_added column

=IF(WEEKNUM([@[date_added]])<=9,"0","") this adds 0 till the week is up to 9 so the week number come as 01,02,03,04,05,06,07,08,09 going to 10,11 etc....

but for some odd reason it calculates the 28/02/2016 as 9 and not as 09 regardless of what I do it calculates that date as 9 and not as 09 which is causing issues when I creating Pivot table and trying to perform average over the weeks.

This behavior can be tested using the formula below, just copy and past in Excel and you will see this anomaly. Any help would be appreciated.

=IF(WEEKNUM(DATE(2016,2,28))<=9,"0","")



I am using MS Office 2010 and any help would be appreciated.

kind regards,

Why not =text(weeknum(your-date),"00")

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post