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" 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" 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 tableNext: How to reduce size of ms excel file-2003