Date is the VBA equivalent to the worksheet function Today.

You can strip the time from Now using Int

Int(now)

demo'd from the immediate window:

? date
1/11/2005
? int(now)
1/11/2005
? now
1/11/2005 11:18:24 AM


--
Regards,
Tom Ogilvy

"mike allen" wrote in message
...
i would like to use "today" in code, but i can't get it to work.
i can use "now" and it works, but i need the integer format that 'today'
provides.
i have tried rounding, declaring at integer, cint(now), etc.
sub temp()
cells(1,1)=today
end sub

thanks, mike allen (seems like my questions are getting simpler, not more
complex like they should be)