Formula

[jimbo125]

Hi all,

You can have a formula =TODAY() which gives you todays date.
Is there a formula that gives you the week number, eg "Wk13"

Many thanks,

Jimbo

 

[j_latendre]

Something like this:

=WEEKNUM(TODAY())

Jesse

 

[VoG]

Hi. Try

=WEEKNUM(TODAY())

This requires the Analysis ToolPak in Excel 2003 and earlier (Tools > Add-Ins).

 

[Jon von der Heyden]

Hi Jim

Use the WEEKNUM function, e.g:

=WEEKNUM(A1)

Where A1 houses the date.

I think this might have been part of the analysis toolpak in version 2003, so if you are using that version (or earlier), make sure you install that addin (Tools > Addins).

Also, if using TODAY(), best would be to house it in a name:

Name: Today
Refers To: =TODAY()

 

[jimbo125]

Thanks very much chaps.

Jimbo.