Formular not working on my computer

[Zundah]

I am working with the following formula that works on my supervisor’s laptop (calculates the week number automatically) but does not work on mine: =ROUNDDOWN((D21-DATEVALUE(CONCATENATE("1/1/",TEXT(YEAR(D21),0))))/7,0). I am using Microsoft Excel 2010. Kindly help.

[TMS]

Maybe try (untested):

=ROUNDDOWN((D21-DATEVALUE(CONCATENATE("01/01/",TEXT(YEAR(D21),"0000"))))/7,0)


Regards, TMS

[TMS]

Or, again untested:

=ROUNDDOWN((D21-DATE(YEAR(D21),1,1))/7,0)


Regards, TMS

[Zundah]

Thanks. Tried but still not calculating.

[TMS]

All three formulae work and produce the same result on my laptop running Excel 2007:

So, when you say

but does not work on mine

and

Tried but still not calculating

what *does* it do?

Do you have other formulae in the worksheet/workbook? And, if so, do they work?

It may be sensible to post a sample workbook that exhibits the problem.

Regards, TMS

[Zundah]

Thanks man. They all work. Date formats were incompatible. Thanks again.

[TMS]

You're welcome.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[Zundah]

Where does one select "Solved"?

[Zundah]

I got it. Thanks.