A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can Excel automatically insert current date in a cell?



 
 
Thread Tools Display Modes
  #21  
Old June 3rd, 2010, 07:42 AM posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets
external usenet poster
 
Posts: 397
Default 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?


  #22  
Old June 3rd, 2010, 09:42 AM posted to microsoft.public.excel.worksheet.functions
steve
external usenet poster
 
Posts: 28
Default How can I insert a date which is the first date of the following m

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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query for 'confirmation' rogge Running & Setting Up Queries 8 April 19th, 2005 03:26 PM
How can I get the current date to insert automatically when I se. cit General Discussion 0 March 30th, 2005 11:09 PM
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? oil_driller General Discussion 1 February 8th, 2005 10:34 AM
How to insert future date based on current date plus 14 days John Bakker General Discussion 1 January 31st, 2005 10:08 PM
Aggregating Date Data into Weeks and Quarters Roger Running & Setting Up Queries 3 July 11th, 2004 05:56 PM


All times are GMT +1. The time now is 12:00 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.