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