Date formats

P

Penco Excel User

Hi,

I am making a 12 month column report. I want the user to able to chose up to
which month actaul data will be retrieved and going forward budgeted data.
Can somebody help me with this?
 
B

Bob Phillips

=MONTH(TODAY())

gets the month of today's date, and you can use that as your column offset

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top