I talked already about this in the past, but I think it should implemted as idea.
I need constantly to compare same month date, or check if one date is previous month of another date. Same thing for days.
I believed it should exsist a comparator for months or days that ignores hours, minutes and so.
Or a converter that extract the month not as a number, but as actual date month/year… Does make it sense?
What are you trying to compare? What’s the result you’re looking for?
Example 1. I have date A and date B.
I want to a sime condition: if month A is before month B.
Example 2: date A is the same month of date B.
Example 3: date A is within months of date B and date C.
Right now I can obtain these results with several and or or conditions (extract month A = extract month B AND extract year A = extract year B )
Moreover, In some situations (conditional formatting) I have limitations on the length of the condition!
Anyone?
I’m having a hard time following your examples, to be honest. Let me try to see if I understand:
Example 1: You want to know if Andrew’s Starting Month is before Rachel’s Starting Month?
Example 2: You want to know if Andrew’s Birthday is the same as Jamie’s birthday?
Example 3: You want to know if Brad’s Birthday is between Andrew’s Birthday and Jamie’s Birthday?
Example 1 and 2 are correct.
Example 3 is only about months. Month of date A is equal or later than month of B AND equal or before month of date C.
I really find hard to believe this is only my issue. Must be somehow described differently in the forum and o cannotto find it…
I guess I don’t understand the issue. Why can’t you check if User A’s Date is < User B’s Date AND User A’s Date is > User C’s Date?
Let’s try again: I want a condition for: MonthC is > monthA and < monthB.
MonthA, B and C are date type.
Currenty I have to do something like this (dont’ mind the <-min-> and <-max-> functions…):
Hope is more clear. I just want to understand tif this is the best approach or there something smarter.
Thanks 