Posted to microsoft.public.excel.worksheet.functions

Ron Rosenfeld Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

a formula that returns the previous fridays date

On Wed, 12 Mar 2008 15:41:01 -0700, pdberger
wrote:

=A1-WEEKDAY(A1)-1

That generated 3/7 through the end of the week, then 3/14.

But he wanted 3/7 until 3/14
--ron

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
date formula returns the 15th or the end of month	Steve	Excel Worksheet Functions	8	January 2nd 08 06:31 AM
formula for last Fridays date	Pete	Excel Discussion (Misc queries)	6	February 20th 07 06:18 PM
show fridays	Tanner	Excel Worksheet Functions	2	March 27th 06 02:43 AM
Have a date chane if it is +/- 2 days from the previous date	Gohan51D	Excel Discussion (Misc queries)	1	March 10th 06 09:23 PM
In excel,how do I change the date to a date 84 days from previous	Alister Edmond	Excel Discussion (Misc queries)	3	February 9th 06 02:24 PM

All times are GMT +1. The time now is 03:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us