Using numbers v14.1 on Mac can weeknum ref a cell?
WEEKNUM("01/9/2025",1) returns the week number but can the date be in a different cell?
for example if the date is in F3 then WEEKNUM("F3",1) does not work, is there a way of doing this?
iMac 21.5″ 4K, macOS 13.7
This is also true for any reference in Numbers.
If the value is quoted, it's taken as a literal string entry, so "F3" is interpreted as, literally, the characters F and 3. Clearly there's no way Numbers can infer a 'week number' from "F3"
Without the quotes Numbers interprets the values as references, so F3 is taken as the current value of the cell F3, which is what you want in this case.
This is also true for any reference in Numbers.
If the value is quoted, it's taken as a literal string entry, so "F3" is interpreted as, literally, the characters F and 3. Clearly there's no way Numbers can infer a 'week number' from "F3"
Without the quotes Numbers interprets the values as references, so F3 is taken as the current value of the cell F3, which is what you want in this case.
Hi Notehideas,
Remove the quotes around the cell reference.
Instead of WEEKNUM("F3",1), use WEEKNUM(F3,1)
Regards,
Ian.
Thank You.
These things are easy when you know how!
Using Weeknum in apple numbers
