=today() = weeknumber

D

Derek M

Hi all

I wonder if this is possible, in cell A1 e.g. i have =today()

Is it possible in cell A2 to get it to calculate and show what week number
this is?

Thanks as always

Derek
 
R

Ron Rosenfeld

Duh, sussed it =WEEKNUM(A1)

Sorry for the wasted post :)

:
Click to expand...

OK, but keep in mind that Excel's weeknumbers are not computed the same as the
ISO standard. So be certain of what you want. If you require ISO weeknumbers,
post back for a UDF.
--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Excel does not accept text format! 0
Show value from one cell in another cell if today falls between a date range 5
Match date to today 6
need help in creating a formula 1
Date + relative number reference 3
Autonumber field in Excel that behaves the same as Access 0
How to set formula for poping up the date of next Wednesday.... 2

Top