View Single Post
  #19  
Old June 3rd, 2010, 07:26 AM posted to microsoft.public.excel.worksheet.functions
Md. Muhasenul Haque
external usenet poster
 
Posts: 1
Default How can I insert a date which is the first date of the following m

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?