If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
=if(h1800;e180-$j$1;0)
Hello everyone
Sorry about my typing error but everything should now be correct =IF(H1800;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 Last edited by paulrm906 : February 13th, 2006 at 09:03 AM. Reason: Sorry Mistake in formula |
#2
|
|||
|
|||
=if(h1800;e180-$j$1;0)
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" wrote in message news Hello everyone Sorry about my typing error but everything should now be correct =IF(H1800;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 -- paulrm906 |
#4
|
|||
|
|||
=if(h1800;e180-$j$1;0)
On Mon, 13 Feb 2006 07:51:26 +0000, paulrm906
wrote: Hello everyone Sorry about my typing error but everything should now be correct =IF(H1800;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] |
Thread Tools | |
Display Modes | |
|
|