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
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
=DATE(2015,12,IF(A1<=DATE(2015,12,15),15,31))
Return to General Excel Questions
Users browsing this forum: No registered users and 221 guests