Get instant live expert help on today function in excel
“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
One month ago, I set up the function "mvemp" in my Excel 2010 file and worked fine. Today when I re-open this file and found "MVEMP" does not work and showed "#NAME?" Why?
Solved by Z. Y. in 21 mins
I'm trying to create a function which triggers when it has been 3 Days since today date. I have already used to function =TODAY() and put in some dates in other cells, so what I need help with is to make them a function of eachother and in some way create a cell that for example turns red when 3 Days has passed since todays date
Solved by K. E. in 26 mins
=IF(ISBLANK(F3),"",F3-TODAY()) Please help me add another function to this formula, thanks!
Solved by M. L. in 17 mins
Hi I am using today function in my cells.but next day it changes the date automatically. How do I lock the day
Solved by G. B. in 25 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