Working out days remaining

[davidcrawt]

Hi, what formula do I need which will look at a date I have put into one cell and then, working on whatever today's date is, tell me how many days there are left to the same date next year?

[alansidman]

Use the =DateDif function. Here is a link to how to use it.

https://www.techonthenet.com/excel/formulas/datedif.php

[davidcrawt]

Thanks, problem solved.