I am looking to write a formula that calculates the difference (in number of days) from a date in the past (entered in a column) to todays date e.g.

Date 10th April to todays' date (in this case 1st May) answer = 21

Thanks,

Tom