ContributionsMost RecentMost LikesSolutionsUnique week/month start and end daysI have a Daily Date column as well as at Mileage Qty column. I want to create a summary report that shows total Mileage Qty per week and per month. However, my week is Thursday-Wednesday. Also, my month ends on the 21st and begins on the 22nd. Any way I can work around this to create an accurate weekly and monthly summary using those parameters?Re: Nested IF formulaExcellent, that's easy to follow. Thank you, this worked!Nested IF formulaHi everyone, I would like to automate a Status column based on 9 other columns. Most of these other columns are dates but there are two checkbox columns (Reassigned to Drops and New Build). This is what I have so far... I'm not getting an error, but I can tell from the results, only the lines underlined (first two) are actually reading and returning values. If([Permits]="Yes","Permit Pending", If([Reassigned to Drops],"1",[Reassigned to Drops], If([New Build],"1",[New Build], If(not IsNull([Date MDU Splicing Completed]),"Splicing Complete", If([Access Issues]="Not Resolvable","ROE Impasse", If(not IsNull([Date MDU Temp]),"Temp", If(not IsNull([Date MDU Ready to Splice]),"Ready to Splice", If(not IsNull([Date MDU In Construction]),"In Construction", If(not IsNull([Walkout/Survey Date]),"Walkout/Survey","Other"))))))))) Suggestions? Thank you