I have a set of dates on one sheet. My condensed report sheet needs to count the number of items meeting 2 criteria. One is time less that 14 hours and the second would be created date of cell B2. This will be run daily and it needs to grab that date. The date in B2 now is 2/3/2014 formatted as such. The dates on the other sheet I am pulling data from are date and time cells. formatted as "m/d/yyyy h:mm AM/PM". Is there a way to check those cells for only the date portion of the date and time?
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Quang PT
Daily Report - TEST.xlsxDaily Report - TEST.xlsxThank you so much fro your reply! I have attached my file, removing any sensitive data. Other than that, this is the live file with all formulas and record to date. I made notes on the Daily Report sheet of what I need to show and where is pulls from. I also have a second thread that you may be able to help with concerning the same file. it is at http://www.excelforum.com/excel-form...-new-post.html. Let me know if I can get anything else to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks