01/04/2019

Hi there, I would appreciate some help with this one. I would like to return in cell B1, the month and year based on the full date in cell A1, <colgroup><col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;"> <col width="79" style="width: 59pt...

HI Guys i have some date with a date field which contians the date and time like the below 01/04/2019 11:26:23 how can i change this to 01/04/2019 and keep it to a date format? is there a formula that can do this?

After great success in my last post, were I received help with Excel, Im once again seeking the help of 'experts' I have a work log spreadsheet which I need to extract some performance indicators and then present these as monthly graphs. The jobs have a 3 working day pass/fail trigger and...

Hi all, Hoping someone can help me with query I'm having trouble with. I want to do a left join and keep all records in Table 1, and matching records in Table 2 where Table 1 ID = Table 2 ID, AND Table 1 RowDate is between Table 2 StartDate and EndDate. Here is a sample table set up below...

** PLEASE IGNORE - SILLY FIVE MINUTES, NEEDED THE CRITERIA ON MY COUNT!! ** How can I use this formula to find values only after a certain date (01/04/2019). The dates are in column D in the WIP sheet =SUM(LARGE('Dropdown Lists'!U$1:U$22,{1}))

Hi All, I have a daily task where from pivot i have to select yesterday's date and copy the data into another sheet.. is there any way by which i can use macro for the same. What i Do daily is 1- from pivot i select yesterdays date from "create date" column and then copy the data in another...