Automatically subtract one day each day from a total number of days

[snejsnej]

Hello,

Not sure if my search terms are inaccurate, but I haven't had any luck finding a solution for this seemingly simple task.

I have a total number of days (233). I'd like to subtract 1 day every day from this total.

I tried something like this:

=(C10+(K3+L3))-(C10+today())

where
C10 = base date: "7/19/2014"
K3+L3 = total number of days to be subtracted from (236)

...but I ended up with a crazy value.

Appreciate any help-
Cheers,
Jens

 

[Momentman]

Not so sure how you are using it

but for example today's date serial is 41843,

so i can use = 233-today()+41843 - format cell as general

As at today, Today()=41843, so the answer is 233, but tomorrow, today() would have increased by 1, thereby giving us 232 and so on on other days

 

[snejsnej]

Thanks Momentman- I think that does the trick.
Jens

 

[Momentman]

Glad to help

Thanks for the feeback