Formula questions related to dates

Two questions

1) I need a formula that says if prior to 02/01/2002 multiply by 42. If after February 1, 2002 multiply by 36.

2) I also need to use a column going down that starts with 1969 and than the next row down in the same column would be 1970, next row down, 1971. Not sure how to do this. I don't want to spend hours typing in dates.....

Thanks in advance!

Originally Posted by blueglass74

1) I need a formula that says if prior to 02/01/2002 multiply by 42. If after February 1, 2002 multiply by 36.

Assuming that A1 contains the date being compared, and B1 contains the amount being multiplied by either 42 or 36, try...

=IF(A1<DATE(2002,2,1),B1*42,B1*36)

2) I also need to use a column going down that starts with 1969 and than the next row down in the same column would be 1970, next row down, 1971.

Enter 1969 in, let's say, A1

Enter 1970 in A2

Then, select/highlight A1 and A2, move your cursor over the lower right corner of A2 until the cursor changes, click and drag down the column as far as you need.

Hope this helps!