back date calculation?
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 |
back date calculation?
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 |
All times are GMT +1. The time now is 09:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com