i'll have to ask. they probably printed the reports the day before and forgot to
go get them off of the printer. other than that i have no idea.

--


Gary


"NickHK" wrote in message
...
Gary,
I'd go with Niek, as I don't see how Date can return anything else but the
system date.

What do they get by entering =TODAY() in a WS cell ?

NickHK

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
they say no and that it happens on 2 pc's. i have no idea.

--


Gary


"Niek Otten" wrote in message
...
Hi Gary,

<where would it get yesterday's date?

From an incorrectly set system clock?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
|i wrote my app in excel 2003 and my client uses 2002. on the reports in
the
| headers, i use Date to print the current date. client says it prints
yesterday
| instead of today.
|
| here's an example
| .RightHeader = "&B&12 " & Date
|
| anyone seen this? where would it get yesterday's date?
|
| --
|
|
| Gary
|
|
|