Forum Discussion
Solved
Needing Formula help
Hi I'm hoping somebody can help me with the attached spreadsheet please. Why doesn't the formula in K6 return a number? Many thanks Rod
In K2:
=IF(J2="","",DAYS(J2,A2))
In L2:
=IF(J2="","",K2/7)
Select K2 and L2, then fill down.
Thanks for your 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?
In K2:
=IF(J2="","",DAYS(J2,A2))
In L2:
=IF(J2="","",K2/7)
Select K2 and L2, then fill down.
HansVogelaar
Thats brilliant, really appreciate your help
TVM