# Get instant live expert help on I need help with excel todays date

“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 to calculate days past due from due date till todays date
Solved by F. S. in 28 mins
Help me add on one month to todays date.
Solved by G. C. in 15 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
How to make dates that have past todays date go the colour red
Solved by I. W. in 15 mins
I need a simple formula for conditional formatting which will light up a cell if the date in the cell approaches within 30 days from todays date. Example if a cell had 9/30/2018 in it, and today's date is 9/11/2018, the cell would light because todays date is less than 30 days away.
Solved by K. L. in 16 mins