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

Use it like this

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message oups.com...
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

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
oups.com...
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

Hi Dan,
A simple misplaced parenthesis
Use =IF(DAY(C2)15,1,2)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
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

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