I have the formula as =TODAY ()
"The rule is, jam to-morrow and jam yesterday – but never jam to-day."
"It must come sometimes to 'jam to-day'," Alice objected.
"No, it can't," said the Queen. "It's jam every other day: to-day isn't any other day, you know."
"I don't understand you," said Alice. "It's dreadfully confusing!
I just get a paste special window that gives me options for selection, operations, skip empty cells and shift cells. I think im either missing something or im not copy and paste special correctly?
I'll keep my fingers crossed that the date july 20 19 will also show up tommorow when i open the sheet.
Open Office 3.1
=IF(A2="";"";IF(CELL("TYPE";B2)="v";B2;TODAY()))
has a built-in shortcut Ctrl+Alt+Y which inserts today's date as a constant value into the active cell.
Users browsing this forum: No registered users and 9 guests