Date near end of month checkbox
I have a sheet that contains a column titled Billing Date. This column is used to run revenue reports by month. I would like to add a column to my sheet with a checkbox that is only checked if the Billing Date is near the end of the month. Say, within 3 days of the end of the month. We'll call this new column End of Month.
I'll use May as an example. There are 31 days in May. So each line with a Billing Date of 5/29, 5/30 and 5/31 would all have a check mark in the column End of Month.
I've done a bit of searching and can't seem to find a formula that will accomplish this. Any assistance would be appreciated.
Help Article Resources
Check out the Formula Handbook template!