SharePoint Calculated Column Formula Issues

Question

Hey all. I am attempted to do a calculated column based on a data column called "Resolved Date". The first formula is working but when I try to add an ISBLANK statement at the beggining is breaks the formula. I think I am missing a parathesis or need to add one.

=IF(INT(([Date Resolved]-DATE(YEAR([Date Resolved]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Date Resolved]),1,1)-1),”d”)))/7)=0,52,INT(([Date Resolved]-DATE(YEAR([Date Resolved]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Date Resolved]),1,1)-1),”d”)))/7)) --- This works but I want to add isblank at the beginning IF(ISBLANK([Date Resolved]),"",INT(([Date Resolved]-DATE(YEAR([Date Resolved]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Date Resolved]),1,1)-1),”d”)))/7)=0,52,INT(([Date Resovled]-DATE(YEAR([Date Resolved]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Date Resolved]),1,1)-1),”d”)))/7)) -- This is the code that is giving me an error. I think I am missing a paraethissAny help would be very appreciated!!!

Answer 1

Dear David,

Thanks for your updates and kindness.

I appreciate it as it may help other community members who are experiencing the similar issues.

Welcome to post a new thread on our forum at your convenience if you encounter any issues.

Thanks for your effort and time!

Sincerely,

Cliff | Microsoft Community Moderator

Answer 2

IF(ISBLANK([Date Resolved]),"",IF(INT(([Date Resolved]-DATE(YEAR([Date Resolved]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Date Resolved]),1,1)-1),”d”)))/7)=0,52,INT(([Date Resolved]-DATE(YEAR([Date Resolved]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Date Resolved]),1,1)-1),”d”)))/7)))

Works if anyone has this issue