# Date in "If" formula

Hi,
I am trying to setup an if statement to calculate the \$ amount for all jobs
approved but not yet started.

i need to know how to write ex: "if A3 has a date then calculate the
formula" into the "if statement".

Column F= Date Approved
Column G= Estimate Amount
Column L = Invoice date
Column H = Date Started

So if there is a date in F20 and no date in L20 and no date H20 then 0
otherwise G20
So far i have =if(and(L20=" ",H20=" ",f20=DATE???),G20,0)
I get lost at the date part...hopefully i'm on the right track..

*The reason i have included date started is because i have to setup a
different formula for jobs that have been started and not yet approved.
Any help would be appreciated.
Thanks :)
.

## Relevant Pages

• Re: Cameron Bastards war on 5 million benefits
... of disabled/sick people unable to work in this country? ... If there are no jobs for 5 million people then they are unable to work. ... A relatively small amount of money might seem, initially, to suggest that the ... of past contributions, but means-tested benefits are... ...
(uk.politics.misc)
• Re: Wife scared to dive due to "Open Water" movie
... The amount of work required will be different for different ... >> people and differnet goals, but the amount of work is directly ... >> to make that goal a reality, my chances of success are very good. ... > After 2 jobs and the household to take care off... ...
(rec.scuba)
• Re: Practical Ideas
... Instead of cutting new shapes into a vise's soft jaws for repeat jobs, I drill and ream two 0.2505-in.-diameter holes into each soft jaw and into the vise at 5.250-in. ... Sub-plates, which are plates with a series of holes spaced at predetermined intervals, are an effective means of assuring repeatable positioning of fixtures. ... Setup records should then indicate which holes to pick up when positioning fixtures used on different jobs. ...
(alt.machines.cnc)
• Re: Don Imus Is a Joke
... Fools like this should not only lose their jobs over things such as ... but there should be more punishment. ... Really, he should have to pay them a certain amount of money, enough ... for real atonement and not to simply have to pay money for his ...
(rec.sport.football.college)
• Re: Don Imus Is a Joke
... Fools like this should not only lose their jobs over things such as ... but there should be more punishment. ... Really, he should have to pay them a certain amount of money, enough ... for real atonement and not to simply have to pay money for his ...
(rec.sport.football.college)