Hi I have 3 cells E1,F1,G11



I want to store cell IDs containing dates in E1 and F1. Cell G1 will show the number of days difference.

EG:

E1 = '06/04/2017 19:00:00'
F1 = '28/04/2017 19:00:00'
G1 = '22 Days'

I tried entering =DATEDIF(F1,E1,"D") into cell G1 but it doesn't work.

Change to:

=DATEDIF(E1,F1,"D")

=DATEDIF(F1,E1,"D")
=DATEDIF(E1,F1,"D")

All you have done is reversed the 2 cells. This would give a negative value but it doesn't work.

Have you actually tried?

What do you mean by "giving a negative value"?

Attached Files

Datedif.xlsx (13.8 KB, 9 views)

No you are missing the point.

Cell B2 has the date Value "25/03/2017 11:30:00"
Cell B8 has the date value "31/03/2017 12:00:00"

NOW
I am going to but into cell E2 the text value 'B2'
I am going to but into cell F2 the text value 'B8'

What I want to put into cell G2 is a calculation which requires it to LOOK at Cell E2 find the contents of that cell and look at as a pointer to the cell containing the date.

Cell E2 and F2 don't have a date value just the pointer to the cell that has the date. It is a reference/pointer

How about the attached?

Attached Files

Datedif_2.xlsx (14.1 KB, 15 views)

Is everybody over thinking this ?

G1 = F1-E1
Format G1 as Month, if the answer insn't allready correct.

Thanks XOR
=DATEDIF(INDIRECT(E2),INDIRECT(F2),"d")

Never heard of INDIRECT(...)

Just be aware that INDIRECT is a volatile function

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

INDIRECT is volatile? Not sure what you mean by this!

http://www.decisionmodels.com/calcsecretsi.htm

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post