Posted to microsoft.public.excel.misc

TUNGANA KURMA RAJU TUNGANA KURMA RAJU is offline

external usenet poster

Posts: 171

find date of last weekday of a month

I need a function/formula to get date of last friday of a month.
if cell A1=10-OCT-2006 --- RESULT IN cell B1=27-OCT-2006
if cell A1=01-SEP-2006 ----RESULT IN CELL B1=29-sep-2006.

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
holiday dates	bucci	Excel Worksheet Functions	4	June 15th 06 09:35 AM
Find category value based on date range?	thewiz1972	Excel Worksheet Functions	5	June 10th 06 03:28 AM
average value from a table	TUNGANA KURMA RAJU	Excel Discussion (Misc queries)	15	March 21st 06 06:52 AM
Get month from date	[email protected]	Excel Discussion (Misc queries)	2	November 9th 05 02:43 PM
Pulling a date in the current month	Brian	Excel Worksheet Functions	2	October 24th 05 05:57 PM

All times are GMT +1. The time now is 05:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us