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:
 

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

separating date and time 5
time_report_date-wise_employee-wise 6
Access Running Balance in Access 1
Delete rows with date more than 48 hours with a condition.. 3
SUM Q 2
compare date and perfom calculation 2
Count entries in the column translating to minutes. 5
Average days between dates 3

Back
Top