Date Question

[Andrew Mackenzie]

In row A I have dates 31-Jan-08, 28-Feb-08, 31-Mar-08...etc.

In row B I want an =IF function such that a certain formula will apply if
the date is 31st December, regardless of the year.

Can anyone tell me how to refer to the date in such a funtion? i.e.
=IF(A1=?????,25*3,25*4) if A1 is 31-Dec-** then 25 times 3, otherwise 25
times 4.

Many thanks for any help

Andrew

 

[Andrew Mackenzie]

Thanks all for a comprehensuive and speedy reply (it was obviously easier
than I thought!).

 

[JE McGimpsey]

One way:

=25*(3 + (MONTH(A1)=12)*(DAY(A1)=31))

 

[Peo Sjoblom]

One way

=IF(AND(MONTH(A1)=12,DAY(A1)=31),75,100)



--


Regards,


Peo Sjoblom

 

[Don Guillett]

try
=if(and(month(a1)=12,day(a1)=31),3,4)*25

 

[Bob Phillips]

=IF(AND(DAY(A1)=31,MONTH(A1)=12),25*3,25*4)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Dave Peterson]

One more:
=if(text(a1,"mmdd")="1231",25*3,25*4)

and another:
=25*(4-(TEXT(A1,"mmdd")="1231"))

This portion:
(TEXT(A1,"mmdd")="1231")
will return true or false. But when excel subtracts it from 4, it'll see
true/false as 1 or 0.

 

[David Biddulph]

I hope you mean =25*(4 - (MONTH..., rather than =25*(3 + (MONTH... ?