date calculation; formula

I have a cell a1 with date say "07/31/2016", I need to populate cell b2 with a date that can calculate fiscal year, when the fiscal year is not same as calendar year. The fiscal year runs from 08/1/20xx to 07/31/20xx+1, For example: for date 07/15/2016 the fiscal year should end on 07/31/2016...

Hello, I have a calendar that I need to use for work that can calculate what the previous Wednesday and Friday is based on the date value in the previous column. The trick is that I need it to calculate which Wednesday and Friday is closest to being 10 days before. That's where I couldn't figure...

I am trying to set up a formula that will allow me to calculate the following information: Each Monday I need to run a report that will calculate information from the coming Thursday minus three weeks to the coming Wednessday minus two weeks. Date examples would be Report run on March 17 for...