Get instant live expert help on I need help with excel current date function

“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

On the SpaServices worksheet, in cell B1, use a function to return the current date.
Solved by D. Y. in 18 mins
I need a formula to count days from an historic date to current date
Solved by T. Q. in 23 mins
Need to know the schedule according to sale date/ last visit date / current date
Solved by G. S. in 16 mins
hey, I am trying to integrate the EDATE function with an IF statement. On an income sheet, I want to be able to automatically populate the estimated figures for a job, using the variables Net Fee, Current Date, Comm Start Date and Contract Length. So for each month, currently there's a formula that says =IF(MONTH(Current Date)=MONTH(EDATE(Comm Start Date, Contract Length)), Net Fee, 0) But this doesn't then continue displaying the Net Fee for the rest of months. What I would like it to do is: =IF(MONTH(Current Date)=MONTH(EDATE(Comm Start Date, [Any number between 0 and Contract Length])), Net Fee, 0) How is this possible?
Solved by E. Q. in 29 mins
I have a problem regarding to Excel DATE Function
Solved by M. W. in 25 mins