date formulas
 

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
--
William

date formulas
 

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

date formulas
 

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))-TODAY()

Regards,
Stefi

€žrwpatter1€� ezt Ã*rta:

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
--
William

date formulas
 

And format reult cell as General!
Stefi


€žrwpatter1€� ezt Ã*rta:

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
--
William