Here are some problems that our users have asked and received explanations on
Hi,
I want to populate current date when one column filled in with a particular value, how to do with Excel vba?
Solved by S. B. in 20 mins
i download excel data. in data show only date. but how to get time also
Solved by T. W. in 26 mins
How can I get this formula to ignore the blank date in I7?:
Formula:
=AVERAGE(DATE(2019,MONTH(I7:K7),DAY(I7:K7)))
Where
I7=blank
J7=5/31/2016
K7=6/8/2015
Current Result: 4/13/2019
Desired Result: 6/4/2019
Solved by V. J. in 20 mins
I am trying to figure out how to calculate a "footage to date" cell that would take the prior days "footage to date" and add the current day's footage. This is a daily report so each day the user would be entering new info for the current day. I am still learning Excel so this may be something that must be done manually.
Solved by Z. D. in 21 mins
I want to take some help related Excel can you help me.
my question is I have current date in one cell and I want to result in other cell for example current date is Mar/06/2018 then add 3 yrs and give me result in other cell.
plz help
Thank you