Excel Help

[Ayla]

Im trying to create a formula in excel, but nothing about it is working correctly.

I'm trying to find the date difference between 2 cells, and if the value is under 30, display 0 and if its over 30 display the number minus 30. (31 days would display 1) But even when I attempt to subtract the dates I get a #value error.

Can someone help me out a bit please?

[Lathais]

http://www.theexceladdict.com/_t/t040303.htm

[Ayla]

http://www.theexceladdict.com/_t/t040303.htm

That's what Im doing. Its not working. So I cant even test my if functions.
=E3-B2 = #Value!
Which in my case looks like E3-CurrentDate = #Value!

[Lathais]

That's what Im doing. Its not working. So I cant even test my if functions.
=E3-B2 = #Value!
Which in my case looks like E3-CurrentDate = #Value!

Keep reading and he explains how to use =DATEDIF. It's working fine for me. Make sure your cells with dates in them are formatted as Date and not General and of course that the formula field is not formatted as Date.

[ReVnX]

That's what Im doing. Its not working. So I cant even test my if functions.
=E3-B2 = #Value!
Which in my case looks like E3-CurrentDate = #Value!

Make sure that the date in E3 is in the correct format

[Ayla]

Keep reading and he explains how to use =DATEDIF. It's working fine for me. Make sure your cells with dates in them are formatted as Date and not General and of course that the formula field is not formatted as Date.

E3 and B1 are both in date format and the cell I am working in is general.
=DATEDIF(B1,E3,"D") or =DATEDIF(B1,E3,"d"). Neither works. So lets just forget that, how would I just work it in to display how I want? An if function or conditional formatting?

This isnt overly important, its just a homework mark. and its preventing me from continuing with the rest of it