=if(h1800;e180-$j$1;0)

[paulrm906]

Hello everyone

Sorry about my typing error but everything should now be correct

=IF(H180<>0;E180-$J$1;0)

H180 = empty cell with a formula in it.
E180 = the date a person was interviewed.
$J$1 = =()NOW

In the above formula H180 is an empty cell with a formula in it (which
will later have their actual starting date in it) and E180 is the date
a new staff member should commence work and J1 is equal to =()now. So
now I want to write a formula simular to the above formula or another
formula that does the job in cell J180 and what I want it to do in cell
J180 is tell me how many days until their starting date. and to do this
I need to subtract E180 (starting date) from J1 (=()now. plus I only
want an answer in cell J180 if they have not started and once I enter
the date in E180 then I just want it left blank. I hope I have not
confused everyone with this as I got totally confused writing it.

Thanks

Paul Maynard

 

[Tom Ellison]

Dear Paul:

This looks very much like a question about the formula for a cell in and
Excel spreadsheet.

Now, the newsgroup to which you posted is for questions in the Access
database product. You may not attract as much expert attention here as you
would in one of the microsoft.public.excel newsgroups. I recommend you
start there.

And, when you have a question of us here, please come back!

Tom Ellison

 

[paulrm906]

Sorry Tom
I will try in future to try and post all of my questions in the
appropriate place.

Paul Maynard

 

[John Vinson]

Hello everyone

Sorry about my typing error but everything should now be correct

=IF(H180<>0;E180-$J$1;0)

You're posting in the wrong place. This is a valid expression for
Excel, but is not for Microsoft Access, the subject of this newsgroup.

Please repost your question in an Excel newsgroup.

John W. Vinson[MVP]