Help with Excel.

[Disco_ute84]

Does anyone on here know much about excel?

I work on a machine that needs a code to be typed in to access certin areas. This code = (day*30) + (month*2) + (year*2), so todays code is 4964.

I have the following formula for excel =(DAY(TODAY())*30)+ (MONTH(TODAY())*2) + (YEAR(TODAY())*2), which works as far as each day I open it, it gives me a new code. However i want to be able to print out the next months worth of codes.

E.G

31/08/2009 = 4964
1/09/2009 = 4066
etc....
etc....

How do I alter the formula to make this work?

Cheers,

Tim

[austastar]

Hi
try a column of dates (do the first 2 dates manually and then extend down as far as you want.
Substitute 'today' with the date column reference.
Set your formula up in an adjacent column and copy down.
cheers

[austastar]

http://www.myswag.org/gallery/d/8676-1/Screenshot.png

Yea it worked.

cheers

[Disco_ute84]

Thanks for that.

It will save me heaps of time.

Cheers,

Tim