View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Md. Muhasenul Haque Md. Muhasenul Haque is offline
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?