Date Formula (Mis)Calculation Assist

%3CLINGO-SUB%20id%3D%22lingo-sub-376969%22%20slang%3D%22en-US%22%3EDate%20Formula%20(Mis)Calculation%20Assist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-376969%22%20slang%3D%22en-US%22%3E%3CP%3EHere%20is%20the%20(simple%3F)%20task%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20wishing%20to%20establish%20the%20correct%20formula%20to%20accommodate%20a%20few%20things%3A%3C%2FP%3E%3CP%3E-First%2C%20to%20be%20able%20to%20discern%20a%20(current)%20age%20of%20living%20individuals%3A%20%3DINT((%24L%241-J36)%2F365)%2C%20where%20L1%20is%20current%20date%2C%20J36%3DBirthdate%3C%2FP%3E%3CP%3E-Second%2C%20I%20wish%20to%20incorporate%20(within%20this%20formula)%20a%20defined%20date%20for%20those%20deceased%3A%20%3D(K35-J35)%2F365%2C%20where%20K35%20is%20the%20Deceased%20date%2C%20and%20J35%20the%20Birthdate%3C%2FP%3E%3CP%3E-Thirdly%2C%20to%20be%20able%20to%20Conditional%20Code%20the%20cells%20with%20Deceased%20Date%20with%20a%20specific%20color%20(i.e.%2C%20Red%20over%20Red%2C%20etc.)%3C%2FP%3E%3CP%3ELess%20the%20(Conditional)%20color%20inclusion%2C%20the%20result%20returns%20an%20error%2C%20inferring%20a%20correction%20of%20%22*%22%20in%20place%20of%20%22%2C%22%20in%20the%20formula%3A%20%3DINT((%24L%241-J29)%2F365)%2C(K35-J35)%2F365%20which%20presents%20a%20completely%20incorrect%20result.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESome%20assist%20in%20the%20formula%20calculation%2C%20please...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-376969%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Here is the (simple?) task:

 

I am wishing to establish the correct formula to accommodate a few things:

-First, to be able to discern a (current) age of living individuals: =INT(($L$1-J36)/365), where L1 is current date, J36=Birthdate

-Second, I wish to incorporate (within this formula) a defined date for those deceased: =(K35-J35)/365, where K35 is the Deceased date, and J35 the Birthdate

-Thirdly, to be able to Conditional Code the cells with Deceased Date with a specific color (i.e., Red over Red, etc.)

Less the (Conditional) color inclusion, the result returns an error, inferring a correction of "*" in place of "," in the formula: =INT(($L$1-J29)/365),(K35-J35)/365 which presents a completely incorrect result.

 

Some assist in the formula calculation, please...

0 Replies