AboutPricing

Get instant live expert help on today in excel

“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.
< Go Back

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

    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
    How do I add determine if date is greater than today in Excel sheet?
    Solved by V. J. in 19 mins
    =INT((Today() - End_Date)/365) Formula is not working in Excel version 98. Pls help
    Solved by O. J. in 25 mins
    =IF(S3="",(TODAY()-I3),(_xlfn.DAYS(S3,I3))) Is there a other replacement formula in excel for above? my excel is older version
    Solved by E. U. in 23 mins
    Need help conditionally formatting dates in a column as follows: Red = less than or equal to today, Yellow = today + 90 days, Green = today + 1 year
    Solved by B. H. in 23 mins