bhaskar28k
New Member
Hi all, greetings.
I've a requirement to validate 3 cells (Ex: Columns F, G, H) which is having 3 different DATES.
1. First I've to format these cells in DD/MM/YYYY format.
2. Have to validate the Dates like H column is less than F / G Column values, this condition should be passed.
3. Have to validate whether H is greater than F / G Column values, this condition should be failed.
Note: There is a chance like F or G column values will be blank.
Please advise and do provide an answer or any formula to overcome this issue.
I've a requirement to validate 3 cells (Ex: Columns F, G, H) which is having 3 different DATES.
1. First I've to format these cells in DD/MM/YYYY format.
2. Have to validate the Dates like H column is less than F / G Column values, this condition should be passed.
3. Have to validate whether H is greater than F / G Column values, this condition should be failed.
Note: There is a chance like F or G column values will be blank.
Please advise and do provide an answer or any formula to overcome this issue.