I'm trying to auto input the date of a column based off a text entry from
another column. I have used the NOW() function as my date but when you use
that formula on the line below, when one updates, they both update & I don't
want that to happen each time a new text is entered. I want the date that is
automatically entered as date with current time so that I can use that
information to validate the correct date if entered before 12, date entered
would be current date & if after 12pm it would be the next day and if entered
on friday after 12 it would be entered as monday.