Posts1Registration dateMonday January 4, 2016StatusMemberLast seenJanuary 4, 2016
Jan 4, 2016 at 11:48 AM
Posts4478Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022
Jan 5, 2016 at 11:38 AM
I have a spreadsheet which using the IF formula should be bringing back either "update Required" or "N/A" depending on if the date in the cell is +21days and greater than today's date. However it is not bringing back the "N/A" false response? $M$1 is ref for TODAY() date. The J column contains either dates, blank cells, or 'TO BE SENT' text.
I hope this makes sense. any help is much appreciated.