PDA

View Full Version : Date Prior to Actual Date



mackypogi
02-23-2015, 08:16 PM
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
12896

HaHoBe
02-23-2015, 11:11 PM
posted as well in
http://www.excelforum.com/excel-formulas-and-functions/1068444-get-date-prior-to-actual-date.html
http://www.mrexcel.com/forum/excel-questions/838050-get-date-prior-actual-date.html
http://www.excelfox.com/forum/f2/get-date-prior-to-actual-date-1992/

Ciao,
Holger