spittingfire
06-02-2015, 06:35 AM
Hi All,
I have the below excel formula that I need some help adjusting
=MOD(DATE(2015,6,20)-TODAY(),-14)+TODAY()
The formula in it's current state works well however what I want now is to modify it to have it kick in at 5:01 PM.
For example the formula will display 5/23/2015 each day until I get to the 6th of June. From June 6th it will display 6/6/2015 until June 20th (14 days later) and so forth. What I want however is for the actual date change to occur at 5:01 PM. So for example on June 6th at 5:01 PM the date change will then take effect.
Is there a way to do this?
Thanks in advance for any help you can provide.
I have the below excel formula that I need some help adjusting
=MOD(DATE(2015,6,20)-TODAY(),-14)+TODAY()
The formula in it's current state works well however what I want now is to modify it to have it kick in at 5:01 PM.
For example the formula will display 5/23/2015 each day until I get to the 6th of June. From June 6th it will display 6/6/2015 until June 20th (14 days later) and so forth. What I want however is for the actual date change to occur at 5:01 PM. So for example on June 6th at 5:01 PM the date change will then take effect.
Is there a way to do this?
Thanks in advance for any help you can provide.