1st and last date of the month from MonthName

Posted to microsoft.public.excel.programming

Abdul[_2_] Abdul[_2_] is offline

external usenet poster

Posts: 137

1st and last date of the month from MonthName

Hello!,

How I could get the starting and ending date of a month based on month
name.

For Eg. say I have combobox1 and textbox1 and textbox2. If i select
january from combobox1 i want to get 1/1/2006 in textbox1 and 31/1/2006
in textbox2 ..

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
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
=VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)6,MONTH(date)-6, MON	Ali	Excel Worksheet Functions	14	January 18th 06 08:20 AM
Determine begin month date from month end date.	mikeburg[_59_]	Excel Programming	3	January 13th 06 08:42 PM
Convert "Month" to "MonthName" format from db to PivotTable	Billabong	Excel Programming	1	August 25th 04 09:14 AM

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

Menu

About Us