Calculate Days Left in Current Year
Thanks Mike ... it worked a treat
"Mike H" wrote:
Hi,
For a running total use
=DATE(YEAR(TODAY()),12,31)-TODAY()
or for a date in a cell use
=DATE(YEAR(TODAY()),12,31)-A1
Where a1 is a date
Mike
"Dave C" wrote:
I need to perform a calculation that returns the number of days that remain
in the current year from a variable date entered into a cell. I could enter
the last day of the year - 31/12/XX - into another cell but this would
require the user to update that value when the year changed. Can I base the
value of the (end of year) cell on a formula so the year changes
automatically when 31 Dec becomes 1 Jan - ie: change from 31/12/08 to
31/12/09 - or is there a formula where I can obtain the number of days
remaining in the current year based on the value entered into the variable
cell?
Thanks for any suggestions /solutions
Dave
|