ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how to fill the coloumn with the calendar automatically (https://www.excelbanter.com/new-users-excel/239726-how-fill-coloumn-calendar-automatically.html)

need help please

how to fill the coloumn with the calendar automatically
 
HELP ME..

Simon Lloyd[_367_]

how to fill the coloumn with the calendar automatically
 

I'm afraid "HELP ME!" doesn't help us to help you, what is it you need
help with? over what range? are there restrictions or conditions?

NEED HELP PLEASE;452772 Wrote:
HELP ME..



--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125322


Gord Dibben

how to fill the coloumn with the calendar automatically
 
Enter a valid date in A1

In A2 enter =A1 + 1

Copy down as far as you wish.

When you change the date in A1 all others will also change.

To just fill a column with fixed dates...............

Enter a date in A1

Select A1 to A100 and EditFill SeriesDateDay

Step Value = 1 and OK


Gord Dibben MS Excel MVP

On Fri, 14 Aug 2009 01:01:01 -0700, NEED HELP PLEASE <NEED HELP
wrote:

HELP ME..




All times are GMT +1. The time now is 11:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com