 SOLVED

# 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