天气预报 > 生活 > 计算年龄的公式
计算年龄的公式
更新时间: 2021-06-02 06:27:53  

1、首先打开Excel,选中“年龄”列表,点击鼠标右键,选择“设置单元格格式”。

2、然后选择“数值”,小数位数设置为“0”,点击“确定”。

3、最后在单元格中输入公式=(TODAY-C2)/365,然后回车即可,鼠标移到单元格右下角,双击黑色十字即可完成整列年龄计算。

关键词: 计算 年龄 公式

计算年龄的公式相关经验

天气预报

最新推荐

页面:/news/view-3471454/ | 耗时:0.8378 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=3471454 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3471454 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3471454 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1117243,1121790,1105787,1084213,1100420,1108359,1095443,1061384,1093825,1122893,1126794,1105405,1097619,1113668,1063493,1110980,1119247,1087803,1123817,1071933,1108864,1111439,1110145,1066240,1124297,1126318,1121650,1081057,1120165,1120320) ORDER BY field (ArticleID,1117243,1121790,1105787,1084213,1100420,1108359,1095443,1061384,1093825,1122893,1126794,1105405,1097619,1113668,1063493,1110980,1119247,1087803,1123817,1071933,1108864,1111439,1110145,1066240,1124297,1126318,1121650,1081057,1120165,1120320)