PDA

View Full Version : Solved: Need Formula for IF (data)



alopecito
11-20-2008, 01:17 PM
I have this problem, I have a database with dates mostly, we update the cells daily, I need a formula to identify when dates are inputed. If there is nothing on the cells (means we haven't start the project, i need the count of the days pass from the first column date until today's date.

See the file attached.


Thanks!

Bob Phillips
11-20-2008, 01:53 PM
=IF(B7="",TODAY()-INT(A7),"Work started")

alopecito
11-20-2008, 02:05 PM
Thanks for your input, but I have another issue, When the column A is empty I need to have something like "not Started" or something like that, the formula you sent me count the days even if the column A is empty...

Thanks

Bob Phillips
11-20-2008, 02:17 PM
=IF(A7="","Not started,IF(B7="",TODAY()-INT(A7),"Work started"))

alopecito
11-20-2008, 02:24 PM
Thanks!

alopecito
11-20-2008, 02:56 PM
I'm sorry but I found another issue, basically I have other columns with dates on it, sometimes we just put dates on those columns, I need your help again because the formula above stated just take B6 (witch is just one column)...How I'm supposed to change the formula to include the other 3 columns with dates on it?

Bob Phillips
11-20-2008, 03:12 PM
Is this what you mean?

=IF(A7="","Not started",IF(AND(B7="",C7="",D7="",E7=""),TODAY()-INT(A7),"Workstarted"))

alopecito
11-20-2008, 03:38 PM
Thanks!!