Hi Guys, cant rack my brain around this I have a column of dates, many are blanks and i am trying to get a formula that calculates if the date in the cell is newer than 1 year ago today so it has to be a rolling number that changes with todays date minus 365
for instance todays date is 22-4-20 and i have some that happened on 23-6-19 then it would return the value true or 1 would be better but if that date was older, say 10-01-19 as in older than 1 year ago from today then it would return 0
Any help would be mostly appreciated
Bookmarks