Forum Discussion
Excel adding days to a date
I am creating a spreadsheet to track the date something was issued and the deadline date of 7 calendar days after with an additional cell showing how many days till due/ days past due. I have added c...
Hi Ryan,
Just use an IF statement like this:
=IF(ISBLANK(J2),"",J2+7)
then for the last formula add an iferror like this:
=IFERROR(L2-TODAY(),"")
Just use an IF statement like this:
=IF(ISBLANK(J2),"",J2+7)
then for the last formula add an iferror like this:
=IFERROR(L2-TODAY(),"")