If clause statement

[sandy]

Hello,

I have a date column from 12/1/2015 to 12/31/2015 and I want to create another column with pay period ending date has 12/15/2015 and 12/31/15.
How do I come up with an IF clause statement?

Thank you

[gebobs]

It's not entirely clear what you want. What is the relationship between the two columns? Is pay period ending equal to 12/15 for any date on or before that and 12/31 for any date otherwise? If that's the case, then this should work:

Code: Select all

=DATE(2015,12,IF(A1<=DATE(2015,12,15),15,31))