Determine if a cell contains a formula (using a formula in another cell)

[Harribone]

Hi,

I'm hoping it is possible to get a solution to this but I have a feeling I may have hit a dead end.

Basically I have a cell, lets say A1, which has the TODAY() function in. Once the wookbook is saved I set this cell to the date (ie. typed in, Ctrl+; ) so if I open the file at a later date it shows the correct data etc etc.

In cell A2 I can type =IF(ISFORMULA(A1),"SET DATE","") to remind me to 'hardcode' the date. This approach isn't backwards compatible with 2010 as ISFORMULA is a new function.

Is there another way (non VB due to security restrictions at work - the only way this seems possible I think) to have a cell show text when another cell contains a formula?

Thanks
Harribone

[AlKey]

Well, if TODAY() formula is in the cell, it will display today's date.

=IF(A1=TODAY(),"SET DATE","")

[Harribone]

I did think of this option but on the day when me and my work colleagues are using the file for the first time it will say 'Set Date' if the formula =TODAY() is in the cell or if the date as a text entry is in the cell

The purpose of this feature would be to notify the user that the wookbook hasn't had the date 'hardcoded'. It's only a minor thing tbh and just curious if it would be possible.