Thread: Date formats
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

=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)


"Penco Excel User" wrote in
message ...
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?

--
Paul P