Creating an Epidemic Curve in Excel 

Hi-- Excel is actually a little smarter than that. When you're creating your "Intervals" line, if you type in two dates (1/25 and below that 1/26), highlight both of those, and then pull them down to copy to more cals, it will automatically figure out the interval in the two cells you highlighted and continue the pattern. This will work not just for dates but for any set of numbers.

You can also certainly create a formula that will count the cases for you.

So if I was using the SIR model to portray a disease outbreak, how would I translate my findings on to excel and eventually make a chart out of it?