Calculating elapsed days

[CrazyChef]

Hey all - thanks for having me here! I have almost zero experience with Excel, and have searched Google extensively but cannot seem to find out how to do this... Basically, I'm setting up a cannabis grow journal (it's legal to grow here in Massachusetts) with multiple plants/strains. What I want to do is calculate the number of days between a specific column date (say, column D) and the current date (say, column K). For instance, column D would contain the dates the seeds were planted, and column K would be the amount of days that has passed since they were planted. Thank you!!!

EDIT: Decided to add a screenshot. I need the column K to show the amount of days since Column D, and Column L to show the amount of days since Column J. Thanks again!!!

cBkyzZR.jpg

[Glenn Kennedy]

Lucky you!!

=today()-D2

and
=TODAY-J2

both copied down. ...failing that, please attach a worksheet, not a non-editable picture of one.

[Glenn Kennedy]

Also. Your thread title was very weak. See Rule 1. What would you have used as a search term on Google? That's the sort of title we expect to see. Since you're new, I have changed it for you... on this occasion. You may expect to find your threads locked until you do it yourself, in the future.

[CrazyChef]

Also. Your thread title was very weak. See Rule 1. What would you have used as a search term on Google? That's the sort of title we expect to see. Since you're new, I have changed it for you... on this occasion. You may expect to find your threads locked until you do it yourself, in the future.

Thank you!

[CrazyChef]

Lucky you!!

=today()-D2

and
=TODAY-J2

both copied down. ...failing that, please attach a worksheet, not a non-editable picture of one.

Thanks! I don't know how to apply formulae yet. I should take a course on Lynda.com to at least learn the basics. In the meantime, I can't attach the worksheet for some reason. Maybe it's because I'm a new member?

[Glenn Kennedy]

Just copy/paste

=today()-D2

into K2 and hit Enter. Then click (and hold) the black blob at the bottom right of K2 and drag the formula down. Release the mouse key. Done.

Re attachments, no there is no restriction on new members. You may have been trying to use the paperclip icon. Very annoyingly, it's been broken for years.

So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[CrazyChef]

Just copy/paste

=today()-D2

into K2 and hit Enter. Then click (and hold) the black blob at the bottom right of K2 and drag the formula down. Release the mouse key. Done.

Now all the cells say "1/1/1900"

[Glenn Kennedy]

Try again to post a sheet. Your pic is impossible to read...

[CrazyChef]

Re attachments, no there is no restriction on new members. You may have been trying to use the paperclip icon. Very annoyingly, it's been broken for years.

So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Yup, that's what I was trying to do. Lemme try again right now - and THANK YOU for your help!!!

[Glenn Kennedy]

Yes. the problem was that column K was formatted as a date. It's not a date just a number of days between dates. Set format as general, and add a wee bit to remove silly answers when blank cells are encountered:

=IF(D2="","",TODAY()-D2)

[CrazyChef]

Yes. the problem was that column K was formatted as a date. It's not a date just a number of days between dates. Set format as general, and add a wee bit to remove silly answers when blank cells are encountered:

=IF(D2="","",TODAY()-D2)

You're absolutely fantastic - thank you! I did the same thing with column L and replaced with J and everything is working perfectly. Off to Lynda.com to see what they have or courses. Thanks again!

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

[CrazyChef]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

Done and done. Thanks again!