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
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