date]]

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")

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...

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...

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...