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