Hi ppl,
I am in great need of some help! I am trying to achieve the following:
I have been asked by work to create a document which effectively counts down the number of days since a pre defined day, for example:
If
Start date = 22/11/1980
Todays date = 27/10/10
I need a way which it can count down the day from today's date till 21/11/10. However I cant change the start date year to make the sum easier
so for example, the answer would be -26, as todays date increased the number of days increases, until there is 0 days left. Then its resets itself and starts counting down from -365 days
I have tried many formula's such as "=SUM(E15-B15)-(365* no of years)" however this forumla doesnt seem to work.
Can anyone help me?
Many thanks!
Tom
Bookmarks