| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
First day of month
A cell in an Excel workbook contains a date. I want to write macro code to
generate, in another cell, the date of the first day of the next month. I was going to use the Excel EOMONTH function, but Excel 2002, does not seem to support the function. I can generate the date using the DATE function, and I tried using Application.WorksheetFunction in my macro, but it did not work with the Excel DATE function. Any suggestions for macro code that will generate the first day of the next month would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtract a future month from the current month to get remaining m. | Excel Worksheet Functions | |||
| Retrieve data for previous 3, 6, 12 month given current month | Excel Worksheet Functions | |||
| Create Month Timetable on a worksheet different month each works | Excel Worksheet Functions | |||
| When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
| transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
Threaded Mode
