Posted to microsoft.public.excel.worksheet.functions

P C Verma

external usenet poster

Posts: 1

WEEKNUM calculations for week stating with Tuesday

While calculating WEEKNUM stating from Tuesday to Friday i am getting error
massage #NUM# but for week staring from Sunday and Monday it calculating
correctly. What could be the reason and how to work around it correctly.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing & Stating The Nearest Matching	FARAZ QURESHI	Excel Discussion (Misc queries)	2	April 11th 08 07:01 AM
Rolling 12 week calculations	Throwme A Frigginbone	Excel Worksheet Functions	2	January 9th 07 09:37 AM
start/end dates of a week given just the weeknum() value	David	Excel Discussion (Misc queries)	4	December 12th 05 03:29 PM
reverse week count calculations	klillestol	Excel Worksheet Functions	1	July 21st 05 11:41 PM
weeknum function says jan1=week1, mod to first 4 day week needed	sam	Excel Discussion (Misc queries)	3	June 13th 05 04:05 PM

All times are GMT +1. The time now is 03:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us