HELP! 🙂 I am trying to work out how i can blank cells when i run a formula and copy it down in a column.
Currently using a formula to count how many days/weeks its been from a specific date to today.
Im using. A1 is a random date
<code>=DATEDIF(A1,TODAY(),"D")/7
</code>
<code>=DATEDIF(A1,TODAY(),"D")/7
</code>
=DATEDIF(A1,TODAY(),"D")/7
When I copy this down the column it obviously shows values where the adjacent cell hasn’t has a specific date entered as of yet.
Can I add to the formula to make the cell blank until the date has been entered to compare?
TIA.
New contributor
John Hulse is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1