Working with Dates.

Here's one strategy for getting timestamps in Excel: http://chandoo.org/wp/2009/01/08/tim...-formula-help/

Hi Tonypg and welcome to the forum,

I believe you will need to do some Event VBA and put the current date in when anything is entered into those date cells. I think the link MrShorty has the VBA code. We could help more if:

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

According to that you are executing the last if:

Formula:

Please Login or Register  to view this content.

If F5 isnt = FALSE then you have no parameter. Try putting something there for the if false arg.

What is the desired result here. So far the logic to me reads: If D5 is blank check F5. If its false return "", if its F5 isnt = false return FALSE (since no argument is provided). If thats the desired result try FALSE or "FALSE" as the argument.

You can also try using evaluate formula on the formula tab to step through the function and see how the logic works out, that may lead you to what the formula is actually returning and why. Hope this helps

PS - I would also point out that the iterative calculation can cause problems in other functions and as far as I know it is a program wide option, not a workbook specific option. I would recommend looking for a VBA/macro solution to what you are doing. You could write it as a UDF (user defined function, essentially used like built in functions/formulas) or potentially on event (Worksheet_Change event likely).