Thread: Date functions
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dianethetech Dianethetech is offline
external usenet poster
 
Posts: 6
Default Date functions

Thanks, that works great.
--
DMM


"Teethless mama" wrote:

Try this:

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


"Dianethetech" wrote:

I am trying to get information using a date.

A B C D

04/28/06 64 1 0

I wrote =IF(A227,B2,C1)

--
DMM