can someone help me on IF formula on excel... I have two columns one column is "start date" and other is "end date", both columns have dates but not in order... and I would like to create another column which shows 2013 of jan feb march etc and in each month to show wither they have been active basically to show the number of days they have been active in each month....so if a person worked from 01-01-2010 to 03-02-2014 then in jan 2013 column it should show 31 days and feb 2013 colume should show 30 days and so fourth... is there is formula for this using IF ?? thanks.