blocks|key|1691323|text|您可以使用datedif函数来找出天数的差异。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1691324|=DATEDIF(A1,TODAY(),"d")|code-block|syntax|javascript|1691325|来自excel.datedif.com的报价|offset|length|style|BOLD|1691326|Microsoft+Excel中神秘的datedif函数|1691327|Datedif函数用于计算以日、月或年为单位的两个日期之间的间隔。|1691328|此功能在所有版本的Excel中都可用，但未记录在案。它甚至没有列在“插入函数”对话框中。因此，必须在公式框中手动键入。语法|1691329|DATEDIF(+start_date,+end_date,+interval_unit+)|CODE|1691330|start_date从日期end_date到日期(必须在start_date之后)用于interval_unit输出间隔值的interval_unit单位|1691331|interval_unit描述|1691332|D天数|1691333|M完整月数|1691334|Y完整年份数|1691335|YD不含年的天数|1691336|MD天数，不包括月份和年份|1691337|YM不含年的月数|1691338|错误|1691339|错误描述|1691340|#NUM！end_date晚于(大于)+start_date，或者interval_unit具有无效值。#VALUE！end_date或start_date无效。|1691341|entityMap^0|0|0|K|2|0|0|S|0|0|X|0|0|1P|0|0|1A|0|1A|0|0|25|0|0|F|0|0|3|0|0|5|0|0|6|0|0|8|0|0|D|0|0|8|0|0|2|0|0|4|0|0|29|0^^$0|@$1|2|3|4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1K|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|1L|8|@$I|1M|J|1N|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|1O|8|@$I|1P|J|1Q|K|L]]|9|@]|A|$]]|$1|O|3|P|5|6|7|1R|8|@$I|1S|J|1T|K|L]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1U|8|@$I|1V|J|1W|K|L]]|9|@]|A|$]]|$1|S|3|T|5|6|7|1X|8|@$I|1Y|J|1Z|K|L]|$I|20|J|21|K|U]]|9|@]|A|$]]|$1|V|3|W|5|6|7|22|8|@$I|23|J|24|K|L]]|9|@]|A|$]]|$1|X|3|Y|5|6|7|25|8|@$I|26|J|27|K|L]]|9|@]|A|$]]|$1|Z|3|10|5|6|7|28|8|@$I|29|J|2A|K|L]]|9|@]|A|$]]|$1|11|3|12|5|6|7|2B|8|@$I|2C|J|2D|K|L]]|9|@]|A|$]]|$1|13|3|14|5|6|7|2E|8|@$I|2F|J|2G|K|L]]|9|@]|A|$]]|$1|15|3|16|5|6|7|2H|8|@$I|2I|J|2J|K|L]]|9|@]|A|$]]|$1|17|3|18|5|6|7|2K|8|@$I|2L|J|2M|K|L]]|9|@]|A|$]]|$1|19|3|1A|5|6|7|2N|8|@$I|2O|J|2P|K|L]]|9|@]|A|$]]|$1|1B|3|1C|5|6|7|2Q|8|@$I|2R|J|2S|K|L]]|9|@]|A|$]]|$1|1D|3|1E|5|6|7|2T|8|@$I|2U|J|2V|K|L]]|9|@]|A|$]]|$1|1F|3|1G|5|6|7|2W|8|@$I|2X|J|2Y|K|L]]|9|@]|A|$]]|$1|1H|3|-4|5|6|7|2Z|8|@]|9|@]|A|$]]]|1I|$]]

You can use the datedif function to find out difference in days.
<pre><code>=DATEDIF(A1,TODAY(),&quot;d&quot;)
</code></pre>
Quote from excel.datedif.com
The mysterious datedif function in Microsoft Excel
The Datedif function is used to calculate interval between two dates in days, months or years.
This function is available in all versions of Excel but is not documented. It is not even listed in the &quot;Insert Function&quot; dialog box.
Hence it must be typed manually in the formula box.
Syntax
<code>DATEDIF( start_date, end_date, interval_unit )</code>
start_date from date
end_date to date (must be after start_date)
interval_unit Unit to be used for output interval
Values for interval_unit
interval_unit Description
D Number of days
M Number of complete months
Y Number of complete years
YD Number of days excluding years
MD Number of days excluding months and years
YM Number of months excluding years
<h2>Errors</h2>
Error Description
#NUM! The end_date is later than (greater than) the start_date
or interval_unit has an invalid value.
#VALUE! end_date or start_date is invalid.

blocks|key|3801911|text|如果这是一个有效的日期/时间条目，那么excel将其简单地存储为一个数字(天是整数，时间是小数部分)，因此您可以进行简单的减法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3801912|我不确定7/6是6月7日还是7月6日，假设是后者，那么它是一个未来的日期，这样你就可以得到天数的差异，如下所示|3801913|=INT(A1-TODAY())|offset|length|style|CODE|3801914|确保将结果单元格的格式设置为常规或数字(而不是日期)|3801915|entityMap^0|0|0|0|G|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@$F|Q|G|R|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

If that's a valid date/time entry then excel simply stores it as a number (days are integers and the time is the decimal part) so you can do a simple subtraction.

I'm not sure if 7/6 is 7th June or 6th July, assuming the latter then it's a future date so you can get the difference in days with

<code>=INT(A1-TODAY())</code>

Make sure you format result cell as general or number (not date)

blocks|key|3801930|text|对于今天和今天的日期之间的差值，您可以输入：=ABS(+A1+()-A1)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3801931|它返回日期之间的(小数)天数。|3801932|你可能会得到一个#值！公式中存在错误，因为Excel将日期视为数字。|3801933|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

For the difference between A1 and Today's date you could enter: 
 =ABS(TODAY()-A1)

which returns the (fractional) number of days between the dates.

You're likely getting a #VALUE! error in your formula because Excel treats dates as numbers.

blocks|key|3802107|text|DAYS(start_date,end_date):|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|3802108|例如：|unstyled|3802109|DAYS(A1,TODAY())|3802110|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|I|3|-4|5|F|7|N|8|@]|9|@]|A|$]]]|J|$]]

<pre><code>DAYS(start_date,end_date):
</code></pre>

For example:

<pre><code>DAYS(A1,TODAY())
</code></pre>

blocks|key|1691382|text|你为什么不让它变得简单简单。如果我需要知道从今天到2015年3月10日之间的天数，我只需输入简单的公式。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1691383|假设静态日期是2015年3月10日，并且是在单元格O5中。|1691384|确定今天与今日之间的天数的公式为：=+O5+-O5()|1691385|没有花哨或者DATEDIF之类的东西。显然，您在其中键入此公式的单元格的数据类型必须为“number”。只需在引用单元格中正常输入日期即可，在本例中为O5。|1691386|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Why don't you just make it easy and simple. If I need to know the number of days between today and say, March 10th, 2015, I can just enter the simple formula. 

Lets say the static date is March 10th, 2015, and is in cell O5.

The formula to determine the number of days between today and O5 would be, =O5-Today()

Nothing fancy or DATEDIF stuff. Obviously, the cell where you type this formula in must have a data type of 'number'. Just type your date in normally in the reference cell, in this case O5.

blocks|key|1468639|text|=ROUND((TODAY()-A1)/365,0)将在单元格A1中提供日期与今天日期之间的年数|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1468640|entityMap^0|0|Q|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

<code>=ROUND((TODAY()-A1)/365,0)</code> will provide number of years between date in cell A1 and today's date

blocks|key|1691431|text|*在所有情况下，#都是指单元格编号|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1691432|您确实不需要datedif函数；例如：|1691433|我正在制作一个电子表格，用来跟踪员工的福利资格。|1691434|我在"A“列中有他们的雇佣日期，在B列中是=(TODAY()-A#)|1691435|您只需设置单元格的格式，以显示常规数字而不是日期。|1691436|它也很容易以另一种方式工作:我还将这个数字转换为显示他们何时获得福利的实际日期，而不是还剩多少天，这很简单|1691437|=(90-B#)%2B今天()|1691438|只需确保将单元格的格式设置为常规数字或日期即可。|1691439|希望这能有所帮助。|1691440|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|Y|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|Z|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|10|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|11|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|S|$]]

*In all instances the # refers to the cell number

You really don't need the datedif functions; for example:

I'm working on a spreadsheet that tracks benefit eligibility for employees.

I have their hire dates in the "A" column and in column B is =(TODAY()-A#)

And you just format the cell to display a general number instead of date.

It also works very easily the other way: I also converted that number into showing when the actual date is that they get their benefits instead of how many days are left, and that is simply

=(90-B#)+TODAY()

Just make sure you're formatting cells as general numbers or dates accordingly.

Hope this helps.

So I have a cell with <code>7/6/2012 10:26:42</code> inputted, I want to show the date difference from today in another cell.

I tried to extract <code>7/6/2012</code> with <code>=LEFT(A1, Find(" ", A1, 1) -1)</code> but turned out theres a value error.

The formula works when I make A1 <code>'7/6/2012 10:26:42</code>, however it is not ideal because I have to work with the whole column.

Excel Calculate the date difference from today from a cell of "7/6/2012 10:26:42"

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

所以我有一个输入了7/6/2012  10:26:42的单元格，我想在另一个单元格中显示与今天的日期差异。我试图用=LEFT(A1, Find(" ", A1, 1) -1)来提取7/6/2012，但是发现有一个值错误。当我创建A1 '7/6/2012  10:26:42时，这个公式可以工作，但是它不是很理想，因为我必须处理整个列。

问Excel从单元格"7/6/2012 10:26:42“计算与今天的日期差值
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Excel从单元格"7/6/2012 10:26:42“计算与今天的日期差值EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Excel从单元格"7/6/2012 10:26:42“计算与今天的日期差值
EN