Need help with a formula question

[swtanjewel]

I am working on a new calendar. However, the first day of my calendar does
not start on the first of any given month. Is there a formula that you can
use to autofill the dates without having to manual input all of them?

[Nav]

You should be able to just enter the first day you require and use the
autofill handle (the cross when you hover your mouse in the bottom right hand
corner of the cell)and drag down to populate the rest of the cells.

"swtanjewel" wrote:

> I am working on a new calendar. However, the first day of my calendar does
> not start on the first of any given month. Is there a formula that you can
> use to autofill the dates without having to manual input all of them?

[oldchippy]

I am working on a new calendar. However, the first day of my calendar does
not start on the first of any given month. Is there a formula that you can
use to autofill the dates without having to manual input all of them?

Hello wtanjewel,

Take a look at this link it may help you

http://www.emailoffice.com/excel/arrays-bobumlas.html

Look for "Creating a calendar with a single array-entered formula"

oldchippy

[swtanjewel]

That was easy enough...
Thank you

"Nav" wrote:

> You should be able to just enter the first day you require and use the
> autofill handle (the cross when you hover your mouse in the bottom right hand
> corner of the cell)and drag down to populate the rest of the cells.
>
> "swtanjewel" wrote:
>
> > I am working on a new calendar. However, the first day of my calendar does
> > not start on the first of any given month. Is there a formula that you can
> > use to autofill the dates without having to manual input all of them?