Thread
:
Can Excel automatically insert current date in a cell?
View Single Post
#
21
June 3rd, 2010, 07:42 AM posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets
external usenet poster
Posts: 397
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?
Arvi Laanemets
View Public Profile
View message headers
Find all posts by Arvi Laanemets
Find all threads started by Arvi Laanemets