Thread: Help with Excel.

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

Thanks for that.

It will save me heaps of time.

Cheers,

Tim