LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default calculate which cells arrives first

I am trying to create a calculate that determines whether or not we
reach a date first or reach a number first. The calculation is for a
retirement date of 30yrs which is in on cell and the other cell has a
calcation for age & years of service. I want to determine whether or
not the 30yrs date is reached before the age + service time reaches
80. I want to know which hits the target first. The set-up is as
follows:

Date of Birth
Date Hired
30 yrs - using EDATE from date hired plus 360 months
current age - using DATEDIF (dob cell,today,"Y")
yrs of serv - using DATEDIF (date hired cell,today,"Y")
age & serv - simply using current age + yrs of service cell)

I am trying to show which cell arrives at its specific destination
first:
*does the 30yr cell (which is a date) arrive at 30yrs before
*age & service arrive at 80 factor first which is a number.

Hopefully this makes sense.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can a cell change colors when the date entered arrives? Peadink Excel Discussion (Misc queries) 1 October 10th 07 09:33 PM
highlight dates when it arrives on a spreadsheet Stephanie Excel Worksheet Functions 1 August 29th 06 02:52 PM
Cells will not calculate Sonya Excel Discussion (Misc queries) 1 October 28th 05 05:40 PM
cells will not calculate jch2005 Excel Worksheet Functions 1 July 22nd 05 01:28 PM
excel spreadsheet with e-mail notification when due date arrives karen gomez Excel Worksheet Functions 2 July 19th 05 11:42 PM


All times are GMT +1. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"