Formula Help

avixion
StarLounger
Posts: 72
Joined: 15 Apr 2017, 17:59

Formula Help

Post by avixion »

Hello there,

I am looking for a formula to keep the amounts in column BR to zero until the system date changes to the date in column BK. Please review the attached worksheet to see if there's a solution.

Thank you
Avixion
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 71516
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Formula Help

Post by HansV »

See the attached version. I also changed the formulas in column BS.

Test.xlsx
You do not have the required permissions to view the files attached to this post.
Regards,
Hans

avixion
StarLounger
Posts: 72
Joined: 15 Apr 2017, 17:59

Re: Formula Help

Post by avixion »

This works great, thank you so much Hans for always being providing the prompt help, I really appreciate being part of this community!
Avixion