| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine begin month date from month end date.
What would be the VBA code to determine the begin month date from the month end date in cell F5 AND put in a variable named BeginMonthDate. For example: F5 = 09/30/2005 need BeginMonthDate to equal 09/01/2005 or F5 = 12/31/2005 need BeginMonthDate to equal 12/01/2005 Thanks a million. mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=501127 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I set a file to auto-open and save at each month begin date? | Excel Discussion (Misc queries) | |||
| Date plus 1 year, but begin of month | Excel Worksheet Functions | |||
| Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| =VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)6,MONTH(date)-6, MON | Excel Worksheet Functions | |||
![mikeburg[_59_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
