Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

1) Make sure "Iterations" are enabled:

Go to Calc. Then (in the menu) go to 'Tools' -> 'Options' -> 'LibreOffice Calc' -> 'Calculate' and make sure the 'Iterations' checkbox is enabled.

2) If the fixed date should be in cell A1 ...

Right click cell A1 and choose 'Format Cells'. On the tab 'Numbers' in 'Category' choose 'Date' and click 'OK' button.

Now enter this formula in cell A1:

=IF(A1="";TODAY();A1)

Current date will appear in cell A1 and is now fixed.

Of course you can extend this formula, for example:

"enter the current date ONLY when a value is entered in cell B1":

=IF(A1="";IF(B1="";"";TODAY());A1)

Now the current fixed date will only appear in cell A1 if you type something in cell B1.

Enjoy ;-)

1) Make sure "Iterations" are enabled:

Go to Calc. Then (in the menu) go to 'Tools' -> 'Options' -> 'LibreOffice Calc' -> 'Calculate' and make sure the 'Iterations' checkbox is enabled.

2) If the fixed date should be in cell A1 ...

Right click cell A1 and choose 'Format Cells'. On the tab 'Numbers' in 'Category' choose 'Date' and click the 'OK' button.

Now enter this formula in cell A1:

=IF(A1="";TODAY();A1)

Current date will appear in cell A1 and is now fixed.

Of course you can extend this formula, for example:

"enter the current date ONLY when a value is entered in cell B1":

=IF(A1="";IF(B1="";"";TODAY());A1)

Now the current fixed date will only appear in cell A1 if you type something in cell B1.

Enjoy ;-)

1) Make sure "Iterations" are enabled:

Go to Calc. Then (in the menu) go to 'Tools' -> 'Options' -> 'LibreOffice Calc' -> 'Calculate' and make sure the 'Iterations' checkbox is enabled.

2) If the fixed date should be in cell A1 ...

Right click cell A1 and choose 'Format Cells'. On the tab 'Numbers' in 'Category' choose 'Date' and click the 'OK' button.

Now enter this formula in cell A1:

=IF(A1="";TODAY();A1)

Current date will appear in cell A1 and is now fixed.fixed :-)

Of course you can extend this formula, for example:

"enter the current date ONLY when a value is entered in cell B1":

=IF(A1="";IF(B1="";"";TODAY());A1)

Now the current fixed date will only appear in cell A1 if you type something in cell B1.

Enjoy ;-)