date formulas

  • Thread starter Thread starter rwpatter1
  • Start date Start date
R

rwpatter1

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
 
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))-TODAY()

Regards,
Stefi

„rwpatter1†ezt írta:
 
Back
Top