Forum Discussion
Advanced if statement and dates
I am trying to make a statement for every month that will determine if we should bill our company or not; and if so the amount of total workable hours per month or if the employee has submitted hours...
can you post some sample data? SWITCH is going to be your friend in these types of situations
Sure, I cannot seem to find a way to attach the excel or pbi file though, how would I do this? I will also note I need this contained in a single formula; this is due to business / report requirements.
Dropbox or one drive link is good
Please use this link to download the example file.