If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
How can I insert a date which is the first date of the following m
Hi
=DATE(YEAR(A1),MONTH(A1)+1,1) Arvi Laanemets "Md. Muhasenul Haque" Md. Muhasenul Haque @discussions.microsoft.com kirjutas sõnumis news: ... Hi, How can I insert a date which is the first date of the following month of a given date. For example, I have a number of dates and I need to put the 1st date of the following month. Can I do it using excel formula? or will I have to inset the 1st date of the following month manually? Muhasenul Haque "AdrianXing" wrote: Does anyone know of a function that can make Excel automatically insert the current date into a cell when a file is opened up? |
#22
|
|||
|
|||
How can I insert a date which is the first date of the following m
In answer to the last sentence you would need to have a macro enabled
workbook with this macro in "ThisWorkbook" Sub Workbook_Open() Worksheets("sheet1").Range("a1") = Now() End Sub This will automatically enter the date when a workbook is opened from information at http://www.ozgrid.com/VBA/auto-run-macros.htm Regards Steve "Md. Muhasenul Haque" Md. Muhasenul Haque @discussions.microsoft.com wrote in message ... Hi, How can I insert a date which is the first date of the following month of a given date. For example, I have a number of dates and I need to put the 1st date of the following month. Can I do it using excel formula? or will I have to inset the 1st date of the following month manually? Muhasenul Haque "AdrianXing" wrote: Does anyone know of a function that can make Excel automatically insert the current date into a cell when a file is opened up? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query for 'confirmation' | rogge | Running & Setting Up Queries | 8 | April 19th, 2005 03:26 PM |
How can I get the current date to insert automatically when I se. | cit | General Discussion | 0 | March 30th, 2005 11:09 PM |
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | oil_driller | General Discussion | 1 | February 8th, 2005 09:34 AM |
How to insert future date based on current date plus 14 days | John Bakker | General Discussion | 1 | January 31st, 2005 09:08 PM |
Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |