How can I insert a date which is the first date of the following m
in [Functions]
|
From: Md. Muhasenul Haque Md. Muhasenul Haque on 3 Jun 2010 02:26 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?
From: Roger Govier on 3 Jun 2010 02:41 Hi With first date in A1, enter in A2 =DATE(Year(A1),MONTH(A1)+1,1) -- Regards Roger Govier "Md. Muhasenul Haque" <Md. Muhasenul Haque @discussions.microsoft.com> wrote in message news:38109FC4-9661-475F-A707-08C7350A8418(a)microsoft.com... > 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? > > __________ Information from ESET Smart Security, version of virus > signature database 5167 (20100602) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > __________ Information from ESET Smart Security, version of virus signature database 5167 (20100602) __________ The message was checked by ESET Smart Security. http://www.eset.com
From: Arvi Laanemets on 3 Jun 2010 02:42 Hi =DATE(YEAR(A1),MONTH(A1)+1,1) Arvi Laanemets "Md. Muhasenul Haque" <Md. Muhasenul Haque @discussions.microsoft.com> kirjutas sõnumis news: 38109FC4-9661-475F-A707-08C7350A8418(a)microsoft.com... > 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?
From: steve on 3 Jun 2010 04:42 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 news:38109FC4-9661-475F-A707-08C7350A8418(a)microsoft.com... > 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?
|
Pages: 1 Prev: Copying daily data from one tab to a weekly summary table Next: Transpose link |