Posted to microsoft.public.excel.misc

Steve[_11_] Steve[_11_] is offline

external usenet poster

Posts: 16

Calculating weeks

Hi

I'm hoping this is more straightforward than I'm making it.

What I want is a formula to look at cell A1 (month) and B1 (year), and
give me the first complete week (ending on a Monday) in that month,
and a second formula to give me the last complete week (ending on a
Monday) in that month. So:

A1 B1
November 2011

result: First 07.11.11; Last: 28.11.11

Any ideas would be greatly appreciated.

Alan

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
Help With Calculating Weeks	Peter From The UK	Excel Worksheet Functions	3	December 30th 07 05:53 PM
calculating number of weeks between two set dates	answer786	Excel Worksheet Functions	2	August 21st 07 04:34 PM
calculating with weeks	Fawn[_2_]	Excel Discussion (Misc queries)	1	July 11th 07 07:32 AM
Formula for calculating the last four weeks	Huber57	Excel Discussion (Misc queries)	1	March 28th 07 02:20 PM
calculating weeks worked	klillestol	Excel Worksheet Functions	2	October 30th 04 04:26 AM

All times are GMT +1. The time now is 07:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us