slinky192001
Board Regular
- Joined
- Mar 16, 2007
- Messages
- 100
Hello,
I want to write and IF formula in Cell A1 which basically says,
if the date and time in cell B1 is equal to or greater than the date and time in C1 and less than or equal to the date and time in D1 then write 'On Time',
if the date and time in cell B1 Falls before the dates and times of cells C1 then write 'Early'
If the date and time in cell B1 falls after the dates and times of cells D1 then write 'Late'.
Can anyone assist me with this???
Thank you in advance
c
I want to write and IF formula in Cell A1 which basically says,
if the date and time in cell B1 is equal to or greater than the date and time in C1 and less than or equal to the date and time in D1 then write 'On Time',
if the date and time in cell B1 Falls before the dates and times of cells C1 then write 'Early'
If the date and time in cell B1 falls after the dates and times of cells D1 then write 'Late'.
Can anyone assist me with this???
Thank you in advance
c