• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Date comparision

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.
 

Attachments

  • Date condition.JPG
    Date condition.JPG
    54.4 KB · Views: 10
A formula like
= (CDS.value>Logon.value)+(SNOW.value>Logon.value)
produces {1,0} but number formatting
"OK";"";"Not OK"
can be used to display text.
The names are used to tidy up the coersion of text dates to numbers.

68013
 

Attachments

  • Calc with text dates.xlsx
    11.5 KB · Views: 3
As you posted a picture ( impossible to work with although nice to look at), I could be wrong, but all your dates seem to be left-aligned.
If that is so without manual alignment, your dates are text looking like dates, not real dates.
If the above do not work, post a sample sheet
 
Back
Top