How to edit this formula to start my day at 6:30am.
I am using this formula to count my fiscal week and it works just fine, but every Monday at midnight, it switches to a new week. I need it to delay the change until 6:30am. How can I edit this formula?
=ROUND(((Modified@row - DATE(2020, 10, 25)) / 7) + 0.49, 0)
Help Article Resources
Check out the Formula Handbook template!