I need to create a calculated column that will read in the date from one column and compare it to today's date. The problem is the the date column is a dropdownlist with dates entered in the format of (MM/YY).
So if today's date is 04/15 and the date the user selected is 03/15 then the calculation would subtract the days in between the dates and in my case I would like them to not be exact but 30 day increments since we don't have exact dates in my columns. So if the dates came out to be 30 then an extra column would have colors that would be Red in the case since the due date is within 30 days.
I was using this formula page to find something comparable to what would work for me in this case since the dates aren't in an actual date field.
Any ideas on how to get started with this?