Quizzes & Puzzles37 mins ago
Excel IF formula and dates...HELP!
3 Answers
I have a list of dates over an entire year.
I want to say 'if a date falls before a set date of 30/06/2010, return a 'YES'. If not, return a 'NO'.
Any ideas?!
I want to say 'if a date falls before a set date of 30/06/2010, return a 'YES'. If not, return a 'NO'.
Any ideas?!
Answers
1 to 3 of 3
Best Answer
No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
Possibly (i don't have Excel to experiment) - isn't a date field basically a numeric value and so you can use a simple 'if A<B' type comparison? (you'd could have a cell containing the date that you want to use and compare with the value contained therein, or just use it temporarily to get the date value)
Only the other hand that ^^^ might be a completely wrong and there's some very simple way to do it.
Only the other hand that ^^^ might be a completely wrong and there's some very simple way to do it.
1 to 3 of 3
