I'm trying to create a calculated column which will return a specific name based on the date in another column.
If the 'week ending' column date is within 28 days, I need the calculated column to say JOHN.
If the 'week ending' column date is more than 28 days away, I need the calculated column to say KARL.
I've been going around in circles and thought this would work, but it does not.....
=IF([Week Ending]<28,"KARL",IF([Week Ending]>28,"JOHN"))
….all of the entries say 'KARL' regardless of the date.
Any help would be greatly appreciated.