Thread: Date functions
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Date functions
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
Reply With QuoteReply With Quote