ExcelBanter - How do I create a formula that inputs the date when a cell equals.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I create a formula that inputs the date when a cell equals. (https://www.excelbanter.com/excel-discussion-misc-queries/13110-how-do-i-create-formula-inputs-date-when-cell-equals.html)

Ant

How do I create a formula that inputs the date when a cell equals.

galimi

Enter =now() for the date/time, which you can then format into the date
format you desire

http://HelpExcel.com

"Ant" wrote:

All times are GMT +1. The time now is 08:43 PM.