How can calculate age in excel?
- 1 Answers
- 813 Views
- I also Faced
- E-Mail Answers
Answer / Seema Gupta
To calculate age in Excel, you can subtract the birth date from the current date. Here's an example formula: =YEAR(NOW()) - YEAR(your_birthdate) - IF(MONTH(NOW()) < MONTH(your_birthdate), 1, 0)
| Is This Answer Correct ? | 0 Yes | 0 No |
How do you delete multiple rows in excel fast?
What is a column break?
What is the definition of goal seek in excel?
What is meant by a macro in ms- excel?
What are the three main parts of a spreadsheet?
What do u mean by append?
How many formulas in ms excel?
How do I search for specific data in excel?
Can we increase the number of rows in excel?
I want to count the number of cells in a range that have a particular interior color. The countif function seems like the right kind of answer but how to I return thecolor of the interior for each cell in a range? I would like to do something like: =countif(b1:b10, cell("interior","red"))?
What an excel file is called?
How do you change preferences in excel?
MS Excel Microsoft 
