Conditional DAY

D

dangerdg

Hi Group,

I am trying to set up a conditional statement that reads the DAY from a
date in a cell, and my formula is not working.

I am trying to make the cell return 1 if the day is >15 and 2 if the
day is =<15

C2 is formatted as a Date cell (type M/DD/YYYY)

My forumula is:
=IF(DAY(C2>15),1,2

Thank you,
Dan
 
B

Bob Phillips

=IF(DAY(C2)>15,1,2)


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
B

Bernard Liengme

Hi Dan,
A simple misplaced parenthesis
Use =IF(DAY(C2)>15,1,2)
best wishes
 
D

dangerdg

Thanks so much everyone! Problem solved... I am new to excel formulas
and appreciate your patience.
 
Top