Posted to microsoft.public.excel.programming

Ben[_14_]

external usenet poster

Posts: 9

a quick way to determine the first and last biz date of the month

Hi all,

I don't remember the code now, but I came across a quick way to
determine the first and last biz date for a specified month using the
dateserial function.

I don't quite know how to how to get dateserial function to work, can
you share some thoughts/suggestions?

Thanks in advance,

Ben

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
Determine qty charged per month	[email protected][_2_]	Excel Programming	1	July 18th 07 07:39 PM
Need a way to determine the # of Saturdays in a month	Chuck M	Excel Worksheet Functions	4	July 5th 07 09:34 PM
Date arithmetic: adding 1 month to prior end of month date	manxman	Excel Worksheet Functions	2	July 14th 06 09:29 PM
Sort month/date/year data using month and date only	SMW820	Excel Discussion (Misc queries)	6	June 22nd 06 05:14 PM
Determine begin month date from month end date.	mikeburg[_59_]	Excel Programming	3	January 13th 06 08:42 PM

All times are GMT +1. The time now is 03:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us