days calculation

ssylee · Jan 10, 2009

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 · Jan 10, 2009

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

ssylee · Jan 11, 2009

Future date in A2.

=A2-TODAY()

Format that cell as General.

Thanks. It works quite well.