Is there some sort of formula that anyone knows of that it if provied
it was a date it will tell me was the date was a number of days before
it.

Ex.. Say i put in a 12/29/2005 as a starting point and I want to know
what the date was 90 days ago....

Bill wrote:[color=blue]
> Is there some sort of formula that anyone knows of that it if provied
> it was a date it will tell me was the date was a number of days before
> it.
>
> Ex.. Say i put in a 12/29/2005 as a starting point and I want to know
> what the date was 90 days ago....[/color]

=DateAdd("d", -90, YourDate)

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Bill wrote:[color=blue]
> Is there some sort of formula that anyone knows of that it if provied
> it was a date it will tell me was the date was a number of days before
> it.
>
> Ex.. Say i put in a 12/29/2005 as a starting point and I want to know
> what the date was 90 days ago....
>[/color]
Yeah. It's called DateAdd. You can even subtract time periods from it.

If you want to find time differences between dates, try DateDiff