days calculation

[ssylee]

Is there any easy way to calculate the amount of days between today
and a specified date in the future (i.e. days left until a certain
date)?

 

[Ross]

a1 is today's date, b1 is future date, c1 is =b1-a1, and format as general?

 

[ssylee]

Future date in A2.

=A2-TODAY()

Format that cell as General.

Thanks. It works quite well.