date minus a day

[amartino44]

Hello. I use a formula that has a date in it 11/15/13 for example. Then I have a formula that calculates "days" (15), but I want to subtract one. How do I do that?

[popipipo]

=(formula)-1
Try this.

[alansidman]

Assume date 11/15/2013 in A1
In A2, =A1-1
in A3, =Day(A2)