Aug-21-2022, 04:14 AM
Hi @CynthiaMoore
Maybe I'm not fully understanding what it is that you're trying to do?
But surely, given the data from Sheet1, would the output in column F, rows 5 through 13, formatted as 'Days to 2 decimal places' not be this?:
Maybe I'm not fully understanding what it is that you're trying to do?
But surely, given the data from Sheet1, would the output in column F, rows 5 through 13, formatted as 'Days to 2 decimal places' not be this?:
Output:0.00
0.00
0.08
1.00
1.00
29.35
31.35
365.00
366.00
Sig:
>>> import this
The UNIX philosophy: "Do one thing, and do it well."
"The danger of computers becoming like humans is not as great as the danger of humans becoming like computers." :~ Konrad Zuse
"Everything should be made as simple as possible, but not simpler." :~ Albert Einstein
>>> import this
The UNIX philosophy: "Do one thing, and do it well."
"The danger of computers becoming like humans is not as great as the danger of humans becoming like computers." :~ Konrad Zuse
"Everything should be made as simple as possible, but not simpler." :~ Albert Einstein