Forum Discussion
Lists calculated column - Last 3 months without the current month (if not complete)
Hi, I have a calculated column in lists that checks a column if the is the word " used" in it and then looks for all fields with "used" in the last 3 months. =IF(AND(used="used",(DATEDIF([use...
I think I advanced a bit unsing the formula
=IF(AND(usedtest="used",(DATEDIF([used date],((TODAY()-(DAY(TODAY())))),"D"))<=90),1,0)
to subtract the amount of days in this months from today, but unfortunately it returns for the field that contains a date of the current month the #num! error.
Any idea for this?
=IF(AND(usedtest="used",(DATEDIF([used date],((TODAY()-(DAY(TODAY())))),"D"))<=90),1,0)
to subtract the amount of days in this months from today, but unfortunately it returns for the field that contains a date of the current month the #num! error.
Any idea for this?