I am looking to use data validation to make sure that dates entered into the spreadsheet fall into a specific range based on an initial date.
Specifically, I want the date entered into column L to be within 3 days of the date entered into column A*. PTSDCP Participant Tracking.xlsx
I have tried using an absolute reference on column A ($A2) so that L2 refers to the date in A2, and L3 refers to the date in A3 ect, but so far the data validation only works for L2 and not any rows below it.
How can I resolve this issue and only use one data validation command (so that it continues referencing each date in the column without creating an individual command for each date)?
Thanks,
dmorl
**I also want the date entered into column O to be within 7 days of the date entered into column A, and the date entered into column Q to be within 14 days of the date entered in column A**
Bookmarks