Hello sir….i want to calculate employee tenure. I know how to calculate when we have start & end date. But when END DATE is not available it should automatically calculate the tenure by taking current date. Pls help me…
Hi everyone, I am looking for a formula to subtract year from age excel. I have the number of years eg. 26 and I'd like to the DOB (01-jan-1995). Essentially I'd like to subtract 26 years from todays date. Greatly appreciated.
Thank you so much for this crash course. I'm having an issue with the final formula: My end value is represented at "21 Yrs6 Mths" There is no space between "Yrs" & "6." any ideas? I've placed an additional space in many of the spots of the equation with no luck, yet. Thank you!