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(C215),1,2

Thank you,
Dan