I opened up a weekly schedule template and I am trying to enter the formula =AND(B4>TODAY(),B4<=(TODAY()+7))
but it is not working. I get January 0, 1900 on B4 that is it. I want to have the first column as todays date for which I used =TODAY() and then =TODAY()+1 and so on. Which works for now.
I want to make it so that I have the next seven days in front of me and I want to be able to figure out if I can exclude Saturday and Sunday from the formula.
HELP.
but it is not working. I get January 0, 1900 on B4 that is it. I want to have the first column as todays date for which I used =TODAY() and then =TODAY()+1 and so on. Which works for now.
I want to make it so that I have the next seven days in front of me and I want to be able to figure out if I can exclude Saturday and Sunday from the formula.
HELP.