Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need a formula that gives me the yesterday (weekdays only not weekends) and a timestamp for 03:00:00 PM or 15:00:00 as 24 hour clock is fine.
I have =Date(FirstWorkDate(today(),2)+15/24,'YYYY-MM-DD HH:MM:SS'), but it's adding 15 to the hours and the minutes are showing 12 for some reason. Currently, that formula is returning 2022-12-07 15:12:00, but I need it to return 2022-12-07 15:00:00.
Can anyone point me in the right direction? Thanks!
=Date(FirstWorkDate(today(),2)+15/24,'YYYY-MM-DD hh:mm:ss')
MM in capital letters means month rather than minutes.
=Date(FirstWorkDate(today(),2)+15/24,'YYYY-MM-DD hh:mm:ss')
MM in capital letters means month rather than minutes.
Thank you so much! That worked. I'm so glad it was such a simple fix.