Get instant live expert help on I need help with todays date 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
Hi there, please can you advise me which formula I can use in Excel to figure out lengths of service? I have people hire date in column and todays date in another
Solved by F. H. in 20 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 calculate days past due
from due date till todays date
Solved by F. S. in 28 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
Help me add on one month to todays date.
Solved by G. C. in 15 mins