Posted to microsoft.public.excel.misc

Eileen[_2_] Eileen[_2_] is offline

external usenet poster

Posts: 1

Display Monday of each week

I have a column with dates, and I need to return the Monday of that week. For
example, I need a simple forumular to return 6/23 (Monday) when I enter 6/25
(Thursday).

Can someone help please ?

Thanks !

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
Changing First day of week to Monday (Excel 2007)	ttt980	Excel Discussion (Misc queries)	4	March 30th 08 09:53 PM
Display Monday or Thursday	Deb	Excel Worksheet Functions	9	January 29th 07 10:25 PM
date of monday of each week automatically	mturner	Excel Discussion (Misc queries)	0	January 5th 06 04:23 PM
How can I get the monday of a given week number?	Gino	Excel Discussion (Misc queries)	2	December 30th 05 06:45 AM
Microsoft Excel : How can we get the date of the Monday of Week 44 of Year 2005?	datt350	Excel Worksheet Functions	1	June 9th 05 01:04 PM

All times are GMT +1. The time now is 04:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us