With your global date in A1 put 42 in B1 in C1 put =A1-B1, will this do what
you want to?

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

wrote in message
ups.com...
I would like to find out what each entry date would be if I had a
global start date, each entry had a day count and the result would be a
backwards calendar count

Example:

If my global date was May, 30, 2006 (05/30/2006)

I had an entry which the day count was 42

The answer for that entry would be the date (MM/DD/YYYY) 42 days before
the global date

Thanks