Adding ISBLANK to existing formula.

[brlattim]

Trying to add ISBLANK to the below formula. Struggling to get it to work. Granted, this is for sharepoint but to my knowledge this formula is the same on both applications. I am struggling to add ISBLANK to this so it returns blanks when Date Requested is blank.

IF(AND(WEEKDAY([Date Requested]) >= 2, WEEKDAY([Date Requested]) <= 6) ,[Date Requested]+7, IF(WEEKDAY([Date Requested]) = 7, [Date Requested]+9, [Date Requested]+8))

Can anyone help? Brain melting from looking at spreadsheets all day.

 

[macattackpro]

Hi,

I'm not sure where you're wanting to insert the ISBLANK function but I am fairly certain empty quotes also works across SharePoint and Excel. "" <- No space. Just quotes.