Forum Discussion
Formula's for moving data
I have a set of dates. What I want to have happen is if the date in column A is older than today (which I have as a control cell with the Today formula in it), I want the date to move to column B an...
I apologize, my work station prevents me from opening attachments. Is there any way to copy/paste them in the reply field. Thank you!
amandanotoriousBOA Okay! Here you have two screenshots. The first one shows the conditional format for column A, The second shows the formula in column B.
Screenshots taken on a Mac, but similar on PC.