LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
LatinViolin
 
Posts: n/a
Default dates, 1st of month

in cell A1 i have 1-jan-2005. i would like to copy this info down into A2,
A3, A4, etc. as long as i like but each cell should read the next month 1st
day. example:

A1 = 1-jan-2005
A2 = 1-feb-2005
A3 = 1-mar-2005
etc.

what formula do i put in A2 and copy it down such each cell below A2 will
come out with the 1st of the month and change years when necessary?

please help.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Month Year Date Format Jamie Excel Worksheet Functions 2 February 7th 05 06:43 PM
How to extract month number from month name PM Excel Discussion (Misc queries) 2 January 19th 05 03:07 PM
due dates Niki New Users to Excel 4 January 10th 05 04:11 PM
How can i filter dates based on day of month Saurabh Excel Worksheet Functions 1 December 12th 04 05:36 PM
Total number of each month in a column of dates GeorgeF. Excel Worksheet Functions 1 November 19th 04 06:10 PM


All times are GMT +1. The time now is 02:44 AM.

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

About Us

"It's about Microsoft Excel"