Date functions

[Guest]

I am trying to get information using a date.

A B C D

04/28/06 64 1 0

I wrote =IF(A2>27,B2,C1)

 

[Guest]

Check your other post

 

[Guest]

Sorry Mike, this is my first time trying to use this and I can't find my
other posting.

 

[Guest]

Try this:

=IF(DAY(A2)>27,B2,C1)

 

[Guest]

Thanks, that works great.
--
DMM

Try this:

=IF(DAY(A2)>27,B2,C1)