If anyone is interested, I just worked out a little template for the spreadsheet mentioned above.
Using this template in the notes section in "My Humidor" on this site:
Source:
Smoked:
Rating:
Review:
(Decided not to be lazy and allow for spaces or not after colon, but make sure to use MM/DD/YYYY formatting (05/01/2017 is same length as 12/12/2017))
Export to excel, then add formulas. (Save this file and in the future just copy paste the export to your file with the formulas, etc)
Date Smoked column:
=IFERROR(TRIM(MID(G2,FIND("Smoked:",G2)+7,FIND("Rating:",G2)-FIND("Smoked:",G2)-8)),"")
Age When Smoked column:
=IFERROR(DATEDIF(D2,H2,"y")&" years "&DATEDIF(D2,H2,"ym")&" months "&DATEDIF(D2,H2,"md")
&" days","")
Or if you don't want X years, Y months, Z days and just want number of days, you can just use
=IFERROR(H2-D2,"")
Source Column:
=IFERROR(TRIM(MID(G2,FIND("Source:",G2)+7,FIND("Smoked:",G2)-FIND("Source:",G2)-8)),"")
Rating Column:
=IFERROR(TRIM(MID(G2,FIND("Rating:",G2)+7,FIND("Review:",G2)-FIND("Rating:",G2)-8)),"")
Review Column: (this will have everything after "Review: ", so if you include anything else it will be in this column)
=IFERROR(RIGHT(G2,LEN(G2)-FIND("Review:",G2)-6),"")