Enter it with Ctrl+Semicolon rather than use a formula

or

Enter it with code
Cells(3,5).Value = Date

or

enter

=today()

then select the cell and do edit=Copy, then Edit=PasteSpecial and select
values.

--
Regards,
Tom Ogilvy

"pamalpass" wrote
in message ...

my mistake. all working fine. i had missed another step in formtatting
my source data. It had blank lines in between the date fields.

i can even automatically create the pivot table now. excellent.

minor issue is that i use the date the report was created (today()) as
a comparison to wrok out the age. However i want this to be a fixed
value and not constantly compared to the 'day' the spreadsheet is
opend.

is there a way of easily doing this?
Paul


--
pamalpass
------------------------------------------------------------------------
pamalpass's Profile:
http://www.excelforum.com/member.php...o&userid=31952
View this thread: http://www.excelforum.com/showthread...hreadid=516726