# date]]

1. ### Converting Text to Date - Formula

Hi Is there a formula where you can convert a text date field to a date field (mmm-yyy) I have the following formula but it is still a text field and when i do an IF statement its not treating the output as a text. =TEXT([@[Due Date]], "mmm") & "-" & TEXT([@[Due Date]], "yyyy")
2. L

### Formula to Calculate Clock Out Time

Hi, Can someone please come up with a formula? If I clock in at 8 am (cell L5) and need to work 9 hours (cell O2) what time do I clock out? There is a lunch break: L2 (12 pm) L3 (1 pm) Also this may be a job that carries over from the previous day as in the 18.0 hour JOB TIME can the...
3. ### Index match with multiple criteria and return the most recent date?

Hi Gents, Can someone please help me out with this greatest challenge I have ever came across? I have a matrix spreadsheet where the column B held the team member names and from column D onward have the headers with the skill code that must be look upon the register table. Here is the...
4. ### If and or - so close..

Hi all I am so close yet so far with this.. looking for some help please. Here's my formula IF(AND([@[Booking Date]]<=\$AH\$1,[@[ Client ID ]]<>"JOHN00",AND([@[Booking Date]]<=\$AH\$1,[@[ Client ID ]]<>"JOHN20",AND([@[Booking Date]]<=\$AH\$1,[@[ Client ID ]]<>"TYCO22",AND([@[Booking...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back