date formulas

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
 
C

Chin via OfficeKB.com

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.
 
S

Stefi

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

Regards,
Stefi

„rwpatter1†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

time_report_date-wise_employee-wise 6
separating date and time 5
Dcount -Date Criteria - Won´t find it - 0
SUM Q 2
How do I count the number of blank cells 0
Calculating an average of data between two dates 1
How to get largest date from a Vlookup 1
date mismatching 2

Top