Prev: Doubt about pivot table
Next: How to reduce size of ms excel file-2003
From: "David Biddulph" groups [at] on 26 Mar 2010 22:29
=TODAY()-A1+SIGN(TODAY()-A1)
Format the result as General, not as a date.
--
David Biddulph


"DyingIsis" <DyingIsis(a)discussions.microsoft.com> wrote in message
news:45927730-23DD-4DE8-AF7C-82E6DDDF0E32(a)microsoft.com...
> Hello -
>
> I'm trying to figure out a formula that tells me the number of days until
> a
> date or tells me how many days have passed since the date.
>
> Meaning, if today is 01/01/10 and my target date is 01/05/10, I would like
> the formula to return "-5".
>
> If today is 01/10/10 and my target date was 01/05/10, I would like the
> formula to return "5".
>
> Any help would greatly be appreciated.
>
> Thanks for your time.


From: Fred Smith on 27 Mar 2010 00:58
Which is the the same as:
=A2-A1

Regards,
Fred

"Huber57" <Huber57(a)discussions.microsoft.com> wrote in message
news:052AF98F-1E9E-4458-9304-E2D1A5DDA72B(a)microsoft.com...
> Can you just put a negative in the formula?
>
> =-(A1-A2)
>
>
>
> "DyingIsis" wrote:
>
>> Hello -
>>
>> Ah, yipes. I should better explain.
>>
>> In Column A, I have my target date sometime in the future.
>>
>> In Column B, I would like it to tell me how many days from today will be
>> my
>> target date. (I want the output to look like a countdown, so the output
>> should be a negative number prior to my target date.)
>>
>> If today is past my target date, I would like the output to be a positive
>> number counting how many days I am already past the target date.
>>
>> Hope that helps to clarify the question.
>>
>> Thanks for your help.
>>
>> "Huber57" wrote:
>>
>> > DyingIsis,
>> >
>> > You can substract dates from each other. Each day = 1. So if you have
>> > a
>> > date in A1 and a date in A2 you can subtract the two.
>> >
>> > Just format the cell as a number (instead of a date).
>> >
>> > Hope that helps. If it has, please rate it as helpful at the bottom of
>> > the
>> > post.
>> >
>> > "DyingIsis" wrote:
>> >
>> > > Hello -
>> > >
>> > > I'm trying to figure out a formula that tells me the number of days
>> > > until a
>> > > date or tells me how many days have passed since the date.
>> > >
>> > > Meaning, if today is 01/01/10 and my target date is 01/05/10, I would
>> > > like
>> > > the formula to return "-5".
>> > >
>> > > If today is 01/10/10 and my target date was 01/05/10, I would like
>> > > the
>> > > formula to return "5".
>> > >
>> > > Any help would greatly be appreciated.
>> > >
>> > > Thanks for your time.

First  |  Prev  | 
Pages: 1 2
Prev: Doubt about pivot table
Next: How to reduce size of ms excel file-2003