 # Get instant live expert help on what is 21 days from today “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I want to make formula saying:- if today date is more than G4 by 21 days, k4 give me red light , but once i inserted date on k4 the red light disappears
Solved by M. B. in 25 mins
I need to calculate tenure in years, months, and days from a specific date until today. What formula do I use?
Solved by A. J. in 12 mins
okay say I have 8/30/2018 on M2 and I want to subtract 21 day from that day on L2 and add 21 day to that day on M4, I need to see a patient 21 days before the due date or 21 day after the due date. This is an example 21 day outlier 21 day outlier 5/26/2018 6/16/2018 7/7/2018 Y3 Z3 AA3 do not know what the formula is
Solved by X. C. in 28 mins
Trying to calculate the average monthly sales, average sales for past 3 days, and average sales for past 7 days into 3 columns. I was working with someone, but what they created was not correct. for 3 days =SUMIFS('PPC Spend Raw'!\$P:\$P,'PPC Spend Raw'!\$A:\$A,"<="&TODAY(),'PPC Spend Raw'!\$A:\$A,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-3))/3 For the past 7 days:=SUMIFS('PPC Spend Raw'!\$P:\$P,'PPC Spend Raw'!\$A:\$A,"<="&TODAY(),'PPC Spend Raw'!\$A:\$A,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-7))/7
Solved by B. U. in 19 mins
This formula is placed in cell C3. =IF(ISBLANK(H3),"", IF(B3="Complete","", IF(H3>TODAY(),IF(TODAY()+H3<>1,CONCATENATE("Due in ",TEXT(TODAY()+H3,"d")," days"),CONCATENATE("Due in ",TEXT(TODAY()+H3,"d")," day")),IF(H3=TODAY(),"Due Today","Overdue")))) When the above formula is run and H3 is today or today-1, then the result in C3 is correct. When H3 is today+1 for example, the result in C3 is "Due in 9 Days". I cannot figure it out ?
Solved by B. U. in 16 mins