ExcelBanter - How to determine the number of weeks at this moment?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to determine the number of weeks at this moment? (https://www.excelbanter.com/excel-discussion-misc-queries/202522-how-determine-number-weeks-moment.html)

Eric

How to determine the number of weeks at this moment?

As we know, there is 52 weeks per year, I would like to determine the number
of weeks at this moment. Does anyone have any suggestions on how to determine
the number of weeks?
Thanks in advance for any suggestions
Eric

Mike H

How to determine the number of weeks at this moment?

Hi,

Try this

=weeknum(TODAY())

If you get a #Name error then
Tools|Addins
Check the analysis toolpak

Mike

"Eric" wrote:

As we know, there is 52 weeks per year, I would like to determine the number
of weeks at this moment. Does anyone have any suggestions on how to determine
the number of weeks?
Thanks in advance for any suggestions
Eric

Gord Dibben

How to determine the number of weeks at this moment?

I suggest you look up the WEEKNUM function in help.

Note............need the ATP loaded.

Gord Dibben MS Excel MVP

On Mon, 15 Sep 2008 03:16:01 -0700, Eric
wrote:

As we know, there is 52 weeks per year, I would like to determine the number
of weeks at this moment. Does anyone have any suggestions on how to determine
the number of weeks?
Thanks in advance for any suggestions
Eric

All times are GMT +1. The time now is 02:30 AM.