If function with date instead of number

**ossa** · 06-26-2012, 05:21 AM

Hello!

I have a list of persons, where each persons have dates, for when going from A to B and from B to A. F. ex person X is going to from B to A on 24.04.2012, and from A to B 25.07.2012. I would like a if function which tells me whether they X are in B or A, but I was not able with normal if function because it looks at the date as it is a number, not a specific date. Does anyone have any ideas, how I can make the if function look at the cell as dates not numbers. hope I made myself clear, thanks for any reply

Ossa

**Fotis1991** · 06-26-2012, 05:31 AM

Hi

I think would be better if you upload a small sample workbook.

**bolekblues** · 06-26-2012, 05:33 AM

Hi

Are the cells formated as dates? To check this, try adding '1' to a cell and see wheteher the result is the next day. Besides, I am not sure this will work with '.'. Try replacing all '.' with '-', so that you have 24-04-2012, etc. Then excel should reat it as dates. Is that what you are asking about?

**ossa** · 06-26-2012, 05:37 AM

Thanks for quick reply.

Attached is my workbookBrigades_18.06.2012.xlsx

**Fotis1991** · 06-26-2012, 05:43 AM

Why this formula, does not works for you?

Give us the expected result and why??

**ossa** · 06-26-2012, 05:47 AM

If you look at person 1. He travels from to Norway 14.04.2012, and from Norway 24.03.2012. Which means he is in Norway now. And if E2>F2 then G2 should be Y2 but it is not, because if I change the format to numbers, F2 gets a higher value than E2

**bolekblues** · 06-26-2012, 05:55 AM

Replace all '.' with '-'. Select the whole two columns with dates and Use ctrl+h (replace all). It should work after this adjustment

**Fotis1991** · 06-26-2012, 06:03 AM

Agree. It's format problem! Your formula is correct and works OK if you change the format in dates.

**ossa** · 06-26-2012, 06:53 AM

Brigades_18.06.2012.xlsxSorry, but I cant make it work, I know about the format. But look here is a sheet with correct format, please take a look if you have time

**Fotis1991** · 06-26-2012, 07:09 AM

I just made a few rows(green color)

**ossa** · 06-26-2012, 07:48 AM

Thanks, exactly. What changes did you make?

**Fotis1991** · 06-26-2012, 07:52 AM

You are welcome.

Nothing more dates format. See the green cells.

**Pepe Le Mokko** · 06-26-2012, 08:00 AM

To easily change your "text" date to real dates, select the column,go to Data -Text to Columns - Next - Next -
In the "column data format" box check Date - Finish

**ossa** · 06-26-2012, 08:49 AM

It worked, thanks a lot for your time!

If function with date instead of number

LinkBack

Thread Tools

Rate This Thread

Display

If function with date instead of number

Re: If function with date instead of number

Re: If function with date instead of number

Re: If function with date instead of number

Re: If function with date instead of number

Re: If function with date instead of number

Re: If function with date instead of number

Re: If function with date instead of number

Re: If function with date instead of number

Re: If function with date instead of number

Re: If function with date instead of number

Re: If function with date instead of number

Re: If function with date instead of number

Re: If function with date instead of number

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions