I am trying to figure out how to create a list of dates between 2 fields. I have a start date and an end date, is there a way to show in another field all of the dates between these two fields?

If you had FM Advanced you could use the DateRange custom function. But, I'd rather explore why you feel the need to do this. Perhaps there's a better method to achieve your goal.

I work for a construction company and we have jobs that last about 3 - 5 days on average. My managers would like to be able to see what days we worked on jobs, but I was thinking that if we used a field that showed us a list we could also search for all jobs worked on during a given day. So, if a job starts on Monday and ends on Friday, if I run a report for all jobs active on Tuesday, Wednesday or Thursday the job would come up on the list. Any suggestions for better ways around this would be appreciated!

You can find using date ranges. So, if you have a Start Date and End Date for each job, you can find records where Start Date >= Desired Date and End Date =< Desired Date.

Ah yes, sorry that's pretty obvious isn't it!

Another thing we were hoping to be able to calculate is job cost per day for our installers. Not sure what a good solution to this would be. If a job lasts 3 days and our crew works varying hours per day, we would like to be able to capture what those hours are and also per person.