Counting number of people who are new hires based on today's date.

[wilsonmedic]

Greetings,

Looking for a formula that will count new hires, based on one year earlier from today's date.

In column E, I have the date that people were hired. For example, 10/12/11.

In column F, I would like an "x" to appear if that date is less than one year from today.

If the date rolls over to more than one year, I would like the "x" to disappear.

Thanks!

[daddylonglegs]

Try this formula in E2 copied down

=IF(DATEDIF(D2,TODAY(),"y")=0,"x","")

DATEDIF will count whole years so before 1 year is up it returns zero.....

......if you just want a count then rather than putting an "x" in each row and counting those you could get that will one formula, e.g.

=COUNTIF(D:D,">"&EDATE(TODAY(),-12))

[MarvinP]

Hi wilsonmedic and welcome to the forum,

Find the attached with your answer.

[wilsonmedic]

Perfect! That is great! Thanks!

[MarvinP]

Why don't I find DateDiff in my function list?

I know I've seen DateDiff but it looks like it is in Access and not in Excel.
http://www.techonthenet.com/access/f...e/datediff.php

[daddylonglegs]

There's a Datediff function in VBA, this is DATEDIF (with one F) - I don't think it's ever been officially explained but DATEDIF doesn't appear in the help files (except Excel 2000) or in function lists.....but you can use it by typing it in, see Chip's explanation here