software

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 gt;15 and 2 if the
day is =lt;15

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

My forumula is:
=IF(DAY(C2gt;15),1,2

Thank you,
DanUse it like this

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

--
Regards Ron de Bruin
www.rondebruin.nlgt; wrote in message oups.com...
gt; Hi Group,
gt;
gt; I am trying to set up a conditional statement that reads the DAY from a
gt; date in a cell, and my formula is not working.
gt;
gt; I am trying to make the cell return 1 if the day is gt;15 and 2 if the
gt; day is =lt;15
gt;
gt; C2 is formatted as a Date cell (type M/DD/YYYY)
gt;
gt; My forumula is:
gt; =IF(DAY(C2gt;15),1,2
gt;
gt; Thank you,
gt; Dan
gt;
=IF(DAY(C2)gt;15,1,2)--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

gt; wrote in message oups.com...
gt; Hi Group,
gt;
gt; I am trying to set up a conditional statement that reads the DAY from a
gt; date in a cell, and my formula is not working.
gt;
gt; I am trying to make the cell return 1 if the day is gt;15 and 2 if the
gt; day is =lt;15
gt;
gt; C2 is formatted as a Date cell (type M/DD/YYYY)
gt;
gt; My forumula is:
gt; =IF(DAY(C2gt;15),1,2
gt;
gt; Thank you,
gt; Dan
gt;
Hi Dan,
A simple misplaced parenthesis
Use =IF(DAY(C2)gt;15,1,2)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

gt; wrote in message oups.com...
gt; Hi Group,
gt;
gt; I am trying to set up a conditional statement that reads the DAY from a
gt; date in a cell, and my formula is not working.
gt;
gt; I am trying to make the cell return 1 if the day is gt;15 and 2 if the
gt; day is =lt;15
gt;
gt; C2 is formatted as a Date cell (type M/DD/YYYY)
gt;
gt; My forumula is:
gt; =IF(DAY(C2gt;15),1,2
gt;
gt; Thank you,
gt; Dan
gt;
Thanks so much everyone! Problem solved... I am new to excel formulas
and appreciate your patience.