How to cover date to one year ago (2005 -> 2004)

[tsunami1977]

I find information on this board to be very helpful, so I hope this question is not too basic.

I have created a set of data for 2004 and 2005. A summary page is using HLOOKUP to pull the right month's data. But if I enter 1/1/05, I need to subtract by 366 to get 1/1/04. This is same for Feb'05. But for the rest of 2005, I only need to subtract by 365. Is there a way for Excel to cover the 2004 to 2005 more simply? The HLOOKUP can only work if the dates are exactly the same, meaning that if the date is 1/2/04, it will not work. It has to be 1/1/04 to work.

Please let me know if anyone can help.

Thank you!

 

[tactps]

How about using this instead (which will always give you same date one year ago) assuming the date is in cell A1:

=DATE(YEAR(A1)-1,MONTH(A1),DAY(A1))

 

[tactps]

How about using this instead (which will always give you same date one year ago) assuming the date is in cell A1:

=DATE(YEAR(A1)-1,MONTH(A1),DAY(A1))

 

[erik.van.geit]

Could you use this?

kind regards,
Erik

Map1
	E	F	G	H
1	1-1-05	1-1-04
2	5-2-05	5-2-04
3	28-2-05	28-2-04
4	1-3-05	1-3-04
5	2-3-05	2-3-04
Blad1

 

[tsunami1977]

Thank you for the quick response! It's amazing! I have it working now.
THANK YOU!