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 ...
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