ExcelBanter - Now date

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Now date (https://www.excelbanter.com/excel-worksheet-functions/232464-now-date.html)

Kay

Now date

is there a formula to make a now date stop at a certain date (example May 30,
2009)?
--
KK

Bob Bridges[_2_]

Now date

Well, I suppose you could use =MIN(NOW(),DATE(2009,5,30)). Will that work
for you?

--- "Kay" wrote:
is there a formula to make a now date stop at a certain date (example May 30,
2009)?

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