P
PZ
Spreadsheet keeps track of date entries as tasks are completed for an
activity in a row.
Looking for a formula to put in a column to check to make sure dates
entered are in chronological order.
Example
Record1
Start Date is in A1
Stage 1 Date is in C1
Stage 2 Date is id E1
End Date is in M1
formula would check to make sure the dates entered did not precede any
of the previous activitiy's dates.
This formula works but it shows true when the cells are blank as well,
plus it gets lengthy the more activity dates you add and you have to
replicate the string for each date cell.
=(a1<>"")*Or((c1-a1)<0,(e1-a1)<0,(m1-a1)<0)
activity in a row.
Looking for a formula to put in a column to check to make sure dates
entered are in chronological order.
Example
Record1
Start Date is in A1
Stage 1 Date is in C1
Stage 2 Date is id E1
End Date is in M1
formula would check to make sure the dates entered did not precede any
of the previous activitiy's dates.
This formula works but it shows true when the cells are blank as well,
plus it gets lengthy the more activity dates you add and you have to
replicate the string for each date cell.
=(a1<>"")*Or((c1-a1)<0,(e1-a1)<0,(m1-a1)<0)