Posted to microsoft.public.excel.worksheet.functions

diggyroo

external usenet poster

Posts: 3

a formula that returns the previous fridays date

I need a date formula that returns the date of the friday from the week
before. For example i need it to return March 07 2008 up untill March 14
2008 the it will return that untill March 28th and so on? Any help would be
greatly appreciated

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 11:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us