Get instant live expert help on I need help with current date and time

“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

in A1 cell, data puts automatically via qr code scanner. cell B1 prints automatically current date and time. I want to set column A for unchangeable after putting one time data. because after changing, column B's date changes to current date and time. And i want to do not enter duplicate data in column A
Solved by T. F. in 21 mins
I need a fixed time and date formula so everytime I enter information into a cell, the current time and date goes into the next cell without changing the time and date of the previous cells like =NOW does
Solved by Z. E. in 13 mins
Hi I need to move current gateway status cell each time an approval date is added... Approval Date Current Gateway Status Pipeline G1 FIA G2 QIA G3 Implementation G4 In Delivery Closed
Solved by A. C. in 19 mins
if column Q (date) <=21 days from current date then: { if the column S > 12 and/or column U > 6000 then display in column V 'Eligible' else display 'Not Eligible' } if column Q (date) >=60 days from current date then: { display in column V 'Eligible' }
Solved by X. J. in 21 mins
I am creating an excel spreadsheet. I want a single cell at the bottom of the table to auto-fill with the current date so each time its saved, it has the balance as of that date.
Solved by S. U. in 30 mins