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 :)