SOLVED

Needing Formula help

Occasional Contributor

Needing Formula help

Hi

Why doesn't the formula in K6 return a number?

Many thanks

Rod

4 Replies

Re: Needing Formula help

The formula

=IF(J6="blank",K6,0)=DAYS(J6,A6)

compares IF(J6="blank",K6,0) with DAYS(J6,A6),

If they are equal, the formula will return TRUE, otherwise it will return FALSE.

Also: did you really want to check whether J6 contains the text blank? Or did you want to check whether J6 is empty?

And: IF(J6="blank",K6,0) refers to K6 itself, so if J6 does contain blank, you'll create a circular reference.

Can you explain what you wanted to accomplish?

Re: Needing Formula help

I wanted the formula to check if J6 is empty then K6 and L6 would also be empty, then when a date was added to J6, K6 and L6 would then return the number of days and weeks respectively.
Hope that makes sense?

best response confirmed by RodDavis (Occasional Contributor)
Solution

Re: Needing Formula help

In K2:

=IF(J2="","",DAYS(J2,A2))

In L2:

=IF(J2="","",K2/7)

Select K2 and L2, then fill down.

Re: Needing Formula help

@Hans Vogelaar
Thats brilliant, really appreciate your help
TVM