I have one that I haven't seen anywhere. Help!
I'm trying to calculate "x Business Days from an entered date" ("A1"), where "entered date" is formatted with a timestamp (mm/dd/yy hh:mm AM/PM).
If I use WORKDAY, my result does not retain the timestamp (mm/dd/yy 12:00AM)
Example: Using WORKDAY to add 2 business days to "02/20/18 02:30 PM" results in "02/22/18 12:00 AM". I need it to show "02/22/18 02:30 PM".
My formula is as follows:
=WORKDAY(A1,2,H2:H22)
I've tried adding multiple hours instead of days (A1 + 48/24) but it does not respect the business hours. It can't be this hard. How do I get WORKDAY to respect the timestamp?
Thank you,
Lizz
Bookmarks