How do I calculate days remaining in a fiscal month?
I need to grab today's date and find out which month it falls into. For example, today's date, according to this calendar, falls in the fiscal month of August. I need to calculate how many days there are left in each fiscal month. The answer here would be today's date (7/29 subtract 08/22) and that answer in a new column…