Get instant live expert help on how to get day from 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
I have a problem regarding to Get day name from date
Solved by E. E. in 23 mins
HOW I CAN SPLIT DAY, MONTH & YEAR INTO 3 COLUMNS FROM DATE COLUMN.
Solved by T. C. in 28 mins
Trying to count and chart how many inventory lots were available on any given date. Question Example: For 9/1/2013 - how many lots were available? Each lot has a "Release Date" and "Expiration Date" and is "Available" every day from the "Release Date" to and including the "Expiration Date". Example: 134530-001 was available every day from 8/8/2013 (day after the "Release Date) and 8/18/2013. Data available is: Lot number (Column A), release date (Column B), expiration date (Column C).
Solved by C. J. in 16 mins
i download excel data. in data show only date. but how to get time also
Solved by T. W. in 26 mins
My invoice number codes are made from using the date. For instance the first invoice for today would be 20180326001 (yyyymmdd001), the second today would be 20180326002 (yyyymmdd002). I am trying to get these codes to generate automatically from Excel when I enter the date I create the invoice... for instance I date each invoice the day I create it: 26/03/18, is there a way to generate an invoice code from the date?
Solved by A. W. in 25 mins