Calculating age, with a hitch

%3CLINGO-SUB%20id%3D%22lingo-sub-2888001%22%20slang%3D%22en-US%22%3ECalculating%20age%2C%20with%20a%20hitch%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2888001%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20a%20new%20user%2C%20I%20am%20using%20the%20format%20in%20the%20attached%20screenshot%20to%20fill%20in%20a%20patient's%20age%20on%20their%20admit%20day.%20It%20works%20fine%20with%20one%20glitch.%20As%20you%20see%20when%20the%20form%20comes%20up%20blank%2C%20the%20DOB%20is%20listed%20as%20121%2C%20once%20I%20enter%20the%20DOB%20it%20is%20fine.%20My%20question%2C%20how%20do%20I%20get%20a%20blank%20cell%20until%20the%20DOB%20is%20entered.%20It%20is%20not%20a%20big%20deal%2C%20but%20my%20ocd%20won't%20let%20it%20slide.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22RNSteve_2-1635284237334.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F320211iE7BBBA0694EB6E13%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22RNSteve_2-1635284237334.png%22%20alt%3D%22RNSteve_2-1635284237334.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20from%20an%20admission%20packet%20at%20the%20clinic%20where%20I%20started%20work%20about%206%20months%20ago.%20I%20am%20an%20RN%20not%20a%20system%20administrator.%20When%20I%20started%2C%20it%20was%2013%20different%20files%20in%20multiple%20formats%20(xlsx%2Cdoc%2Cpdf%2Ctxt).%20These%20were%20all%20printed%20out%20and%20then%20filled%20in%20by%20hand!!!%20(Personal%20data%2C%20med%20history%2C%20medications%2C%20orders%2C%20etc%2C%20many%20of%20the%20items%20were%20repeated%20on%20every%20page).%20Yes%2C%20am%20writing%20this%20from%20a%20medical%20facility%20in%202021.%20After%20about%20a%20week%20of%20this%2C%20I%20taught%20myself%20just%20barely%20enough%20Excel%20to%20get%20this%20all%20put%20into%20one%20workbook%20and%20get%20all%20of%20the%20repeated%20information%20to%20populate%20with%20one%20entry.%20I%20am%20sure%20it%20could%20be%20done%20much%20more%20efficiently%20than%20I%20did%20it%2C%20but%20we%20have%20basically%20moved%20from%20the%20stone%20age%20to%20the%20dawning%20of%20the%20transistor%20age%20already%2C%20but%20I%20am%20curious%2C%20what%20would%20be%20the%20program%20of%20choice%20to%20build%20something%20like%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2888001%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2888106%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20age%2C%20with%20a%20hitch%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2888106%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1196843%22%20target%3D%22_blank%22%3E%40RNSteve%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAbout%20the%20age%3A%20change%20the%20formula%20to%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(OR(I1%3D%22%22%2CE1%3D%22%22)%2C%22%22%2CDATEDIF(I1%2CE1%2C%22Y%22))%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20will%20make%20the%20formula%20return%20a%20blank%20if%20I1%20or%20E1%20has%20not%20been%20filled%20in.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, I am a new user, I am using the format in the attached screenshot to fill in a patient's age on their admit day. It works fine with one glitch. As you see when the form comes up blank, the DOB is listed as 121, once I enter the DOB it is fine. My question, how do I get a blank cell until the DOB is entered. It is not a big deal, but my ocd won't let it slide.

RNSteve_2-1635284237334.png

 

 

 

This is from an admission packet at the clinic where I started work about 6 months ago. I am an RN not a system administrator. When I started, it was 13 different files in multiple formats (xlsx,doc,pdf,txt). These were all printed out and then filled in by hand!!! (Personal data, med history, medications, orders, etc, many of the items were repeated on every page). Yes, am writing this from a medical facility in 2021. After about a week of this, I taught myself just barely enough Excel to get this all put into one workbook and get all of the repeated information to populate with one entry. I am sure it could be done much more efficiently than I did it, but we have basically moved from the stone age to the dawning of the transistor age already, but I am curious, what would be the program of choice to build something like this.

2 Replies

@RNSteve 

About the age: change the formula to

 

=IF(OR(I1="",E1=""),"",DATEDIF(I1,E1,"Y"))

 

This will make the formula return a blank if I1 or E1 has not been filled in.

@Hans Vogelaar 

 

1 million thanks to you!