Date Prior to Actual Date

[mackypogi]

Hi

I am looking for a formula that could get the date prior to the actual date.
The formula like (Date - 1) wont work because it will only get the Date yesterday, what I mean is, I need to get the date prior to the actual date on a list of date to get the data I needed.

kindly see below example
Sample1.png

[HaHoBe]

posted as well in
http://www.excelforum.com/excel-form...tual-date.html
http://www.mrexcel.com/forum/excel-q...tual-date.html
http://www.excelfox.com/forum/f2/get...ual-date-1992/

Ciao,
Holger