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!”
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