根据另一个单元格中的数据帮助向单元格添加日期 [英] Help adding date to cell based of data in another cell

问题描述

我有这个excel表单，我用它来管理计算机漏洞。我认为我提出的功能工作正常，直到第二天我发现使用Today（）会添加当前日期。



我需要帮助修改下面的内容用于保留添加的日期而不是在第二天之后更改它。

I have this excel form that I'm using to manage computer vulnerabilities. I thought the function i came up with worked fine until the next day when i noticed that using Today() would add the current date.

I need help modifying the below function to leave the date it added and not change it after the next day.

=IF(G18="Mitigated",TODAY(),IF(G18="Escalated",TODAY(),IF(G18="Offline",TODAY(),"")))

推荐答案

这篇关于根据另一个单元格中的数据帮助向单元格添加日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！