Get instant live expert help on I need help with excel get day from date

“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

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
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
My working hours are from 9am to 6pm excel has four fields START DATE S,TART TIME AND END DATE END TIME NEED TO CALUCLATE WORKNIG DAY excluding weekend and calculation of working hours and minutes
Solved by M. E. in 12 mins
hi I need I formula to put a date on a excel sheets for example sheet one today date , second sheet tomorrow date , third sheet the day after tomorrow date )
Solved by A. E. in 11 mins