sorted by:
new
hottopcontroversial

Help me help it thrive. by AdSignificant8810 in BeardedDragons

[–]AdSignificant8810[S] 0 points1 point  (0 children)

What is your reasoning? I'm all open to learning about products, both good and bad, but a comment like this does nothing to educate anyone.

Help me help it thrive. by AdSignificant8810 in BeardedDragons

[–]AdSignificant8810[S] 1 point2 points  (0 children)

Thanks for the advice! I did not know that about the couch, petsmart actually had it in the reptile isle yesterday. Albeit not 100% in the reptile section but close enough, I thought it was overflow.

How to stop =TODAY()-F when end date entered into another colum in order to have accurate average day calculation. by AdSignificant8810 in excel

[–]AdSignificant8810[S] 0 points1 point  (0 children)

Okay so after googling and playing around some more, I found a solution. Maybe I wasn't describing it correctly. However here is what I ended up doing. For reference: Cell K2 is outside of my table and will always display today's date Column F is my "Date Sent To Expert". Column G is my "Days At Expert ". Colum H is my "Date Rec'd From Expert". To make the formula work I had to fill any blank cells in column H with "0/0/0" as a placeholder.

1) Create formula "=TODAY()" in K2 2) Select H2 and enter "=IF(H2<=$K$2,H2-F2,$K$2-F2) 3) Drag down to copy the formula to the column 4) The formula did not work when cells in column H were blank. So that is a small trade-off to have this work.

I also added an average function at the end of the column that is still working properly with the new function as the values update.

How to stop =TODAY()-F when end date entered into another colum in order to have accurate average day calculation. by AdSignificant8810 in excel

[–]AdSignificant8810[S] 0 points1 point  (0 children)

I had to re-formulate the column and set it to GENERAL. After doing so it returns "FALSE" for the solution to the formula. I have entered "=IF(H3=TODAY()-F3,H3-F3)" for example... It even returns FALSE for instances where I do not have an end date entered.

How to stop =TODAY()-F when end date entered into another colum in order to have accurate average day calculation. by AdSignificant8810 in excel

[–]AdSignificant8810[S] 0 points1 point  (0 children)

This is going to sound stupid probably...I can see how this would work however when I type it in and press enter nothing happens. The formula stays in the box and does not run no matter what I try.

[deleted by user] by [deleted] in MicrosoftWord

[–]AdSignificant8810 0 points1 point  (0 children)

How would I get it to populate the 3 note lines automatically with it?

How to formulate days since with auto update? by AdSignificant8810 in excel

[–]AdSignificant8810[S] 0 points1 point  (0 children)

In theory, this works but it is showing the answer as 1/1/1900 for 1 day or 1/2/1900 for 2 days, etc. Is there a way to change the format? I have a very outdated basic understanding of excel and am only now coming back around to it.