 # Get instant live expert help on I need help with excel if date is greater than “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

How do I add determine if date is greater than today in Excel sheet?
Solved by V. J. in 19 mins
I need the formula for time accrual to auto populate in E4 based on certain criteria. example: B4 = hire date E4= accrual rate If todays date is equal to or greater than 60 days but less than 1 year from B4 date then E4 = 1 If todays date is equal to or greater than 3 years but less than 4 years from B4 date then E4 = 1.08 If todays date is equal to or greater than 5 years but less than 9 years from B4 date then E4 = 1.5 If todays date is equal to or greater than 10 years but less than 14 years from B4 date then E4 = 1.58 If todays date is equal to or greater than 15 years from B4 date then E4 = 1.92
Solved by A. H. in 18 mins
I need formula for (If the Due Date is greater than 30 days past today's date, then if true "Past Due" if False than "Not Due Yet")
Solved by S. U. in 22 mins
I need help creating a formula. I want to show "If date in cell A1 is greater than a date in a range of cells (B1:B10) then show then next date in that range that is greater than A1". Is this possible to do?
Solved by T. D. in 13 mins
If function for when one date is greater than another that excludes cells with no dates
Solved by E. J. in 30 mins