I have an IF formula that I'm just to get a numerical value from. Currently only getting "Future" text and need it to convert to number.

Hi I'm trying to word on a formula that would (hopefully) give me the week number while also associating with another formula telling me if its a future date or past due date. Currently the column that is supposed to have the number value only comes up with "Future". Any ideas how i fix this? My skills with excel are relatively new.

Last post got taken down because the title didn't contain enough detail. So apologies for the couple people that tried to offer assistance. These were the 2 formulas that were put in my previous posts comments and didn't seem to work unfortunately.

=IF(YEAR(AK2)>YEAR(TODAY()), “FUTURE”, IF(YEAR(AK2)<YEAR(TODAY()), “PAST”, WEEKNUM(AK2)))

=IF(AK2>TODAY(),”FUTURE”, IF(AK2<TODAY(), “PAST”, WEEKNUM(AK2)))

The formula I'm using is below:

=IF(YEAR(@AK2)>YEAR(TODAY()),"FUTURE",IF(YEAR(@AK2)=YEAR(TODAY())),WEEKNUM(@AK2),"PAST")