krishak77
New member
- Joined
- Jun 21, 2021
- Messages
- 6
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2008
Hello All,
I need your support for the below criteria.
I have a data in Excel and which need to mention "Before Cutoff, After Cutoff and Present" on the next to date column.
Date which has yesterday before 5.30pm Should mention as "Before Cutoff" and today's date which has date after 5.30pm Should mention as "After Cutoff"
Data should mention as "Present" from yesterday after 5.30pm to today before 5.30pm, and date should calculate only working days.
Below table with reference.
Cutoff Date
I need Formula as per above criteria.
Thank you in Advance.
Regards,
Anantha
I need your support for the below criteria.
I have a data in Excel and which need to mention "Before Cutoff, After Cutoff and Present" on the next to date column.
Date which has yesterday before 5.30pm Should mention as "Before Cutoff" and today's date which has date after 5.30pm Should mention as "After Cutoff"
Data should mention as "Present" from yesterday after 5.30pm to today before 5.30pm, and date should calculate only working days.
Below table with reference.
Cutoff Date
|
| ||
|
| ||
|
| ||
|
| ||
|
| ||
|
| ||
|
|
I need Formula as per above criteria.
Thank you in Advance.
Regards,
Anantha