Finding the week number 1

[robcarr]

Dear All,

I need to find a formula to find the week no., i had a file sent to me last week with week no 40 on, I need to create a text formula that will show the next/current week no. i was thinking it would be similar to =text(now(),"dd&quot, but I am not sure, as I need this to locate the file I am using in VBA, as all the files have the week no. at the end of the file name, and I need to open the most recent week no each time the report is run, which is weekly.

Any help greatly appreciated.

 

[dwilson01]

The next/current week number would be

nxtWeekNo = Format(Now(), "ww") + 1
curWeekNo = Format(Now(), "ww")

dwilson01

 

[ETID]

if date is in cell A1 then in b1 =WEEKNUM(A1)

 

[robcarr]

thanks ETID, works like a treat