Posted to microsoft.public.excel.misc

Trevor Aiston[_2_] Trevor Aiston[_2_] is offline

external usenet poster

Posts: 17

Financial Year Weeknum

Is there a switch/way in excel to return week numbers from a date other than
1st Jan.

I would like to be able to calculate the weeknumber from 1st april-31st
march our financial year.

Thanks

Trevor

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
Pivot Table by Financial Year	fn450	Excel Discussion (Misc queries)	2	August 27th 08 12:50 PM
year quarters === Financial Year	Saintsman	Excel Discussion (Misc queries)	3	September 12th 07 12:53 PM
How to compare a date with financial year	TUNGANA KURMA RAJU	Excel Discussion (Misc queries)	3	March 31st 07 12:08 PM
Weeknum & Year	AnitaML	Excel Worksheet Functions	2	September 8th 05 03:10 PM
Weeknum Year by Year Compare	RJB	Charts and Charting in Excel	4	December 29th 04 10:33 PM

All times are GMT +1. The time now is 08:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us