Ok that worked, however it is giving me estimate amounts for jobs
that have no date in the approved column but some writting ex..lost bid etc...
Is there any way for it to solve only if there is a date and disregard
anything else that is in that cell?
Thanks for your help

"Saadia" wrote:

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