Hi, assuming the date is located at cell A-1. You may use formula: 365-(today
()-A1).

If the outcome is a 'date' instead of a 'number', just right-click on the
cell, 'format cell' and change it to 'number'.

Hope this helps.


rwpatter1 wrote:
I have a simple question. In one column I have employee start dates. I need
the column next to it to count down the days to one year employed.

i should see today:
1 column next column
03/01/09 339

tommorow it would show:

1 column next column
03/01/09 338

--
Message posted via http://www.officekb.com