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!”
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