I am working on a work project and trying to revamp our calendar task to make it more efficient for each month/qtr end close.
Is there a formula that can give me the date output if the business day is (-2) in row 40 of the attached file. Does anyone have a more efficient way of updating the business day column by automation?
March 28, 2024 MWD -2
Still using Excel 2007??
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I don't understand your request.
What do you expect to see?
Where do you expect to see it?
How would you calculate the result manually?
for example Month BD -2 should be March 28 for reporting tasks done in April for March close
That doesn't help me much. Where/what is Month BD -2???
Alsoe you have not confirmed/updated your Excel product.
Don't forget you KNOW what you're looking at. We don't. Therefore we need a detailed description... not a few cryptic words.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks