Date calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet with employees. Some new some old. A new hire is
considered to have been employed for a period of 6 months. I would like a
formula that takes the current date, the hire date and calculates if the
current date is 180 day greater than the hire date. If it is true I would
like a cell to contain a blank or if it is false I would like the cell to
contain the letter N.

I created =IF(TODAY()>(DATE(2005/05/01)+180)," ","N"). By its part they
work but as a whole I have problems. Can some one please help.
 
Email correction its (e-mail address removed). Please use this address.
I made a slight error on the automatic return email address
 

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

Eligibility Dates 3
Calculating Dates 1
add 2 months and a variable number of days to a date 3
help with functions 3
Dates 2
Date formula 3
Calculate a Date 6
calculate which cells arrives first 1

Back
Top