# Help with Time/date calculation

1. ## Help with Time/date calculation

Sorry I don't know how else to say this. So I am attaching a sheet. I do have some formulas in there now but I have a problem. I have the dates of the enrollments across the top. I have the hire dates. I need to meet with them before 90 days but I want it to be as close to that 90 days as I can get without going over. So if they sent 90 days takes place after the meeting say someone hired on 5/16 I would meet on 7/19 because 8/23 would be after the 90 days. but if they were hired on 5/25 I would meet with them on 8/23. Let me know if that doesn't make sense. Also I would like it to not put an X in the date if I have "Termed" typed in the termed column. Any help or insight would be great.

I know that the current formulas now are not doing what I need because some of my people are over 90 days before meeting. Also, not sure why row 27 and 32 are where they are based on hire date.

Thanks again and ask any questions needed to understand.

Kat

2. ## Re: Help with Time/date calculation

Try this formula in F2:
=IFERROR(IF(LOOKUP(\$B2+90,\$F\$1:\$Q\$1)=F\$1,"X",""),"")

Copy down and across.

3. ## Re: Help with Time/date calculation

That worked but how do I change it to work on my actual speedsheet?

4. ## Re: Help with Time/date calculation

Without knowing how your actual workbook is set up, can't really help you. However, formula is constructed as following.

=IFERROR(IF(LOOKUP(Hire_Date + 90, Range Holding Meet_Date)=Meet_Date,"X",""),"")

You can also add additional condition to leave blank for Termed in Column E. See attached sample.

5. ## Re: Help with Time/date calculation

it is the same but just a different name. I took out people names and locations that are blank on this sheet.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1