Apr 28 2022 09:42 AM
Hey all!
I'm building a spreadsheet to calculate available pto and I need help.
I have two sheets one that holds the calculator and one with a calendar input to add scheduled time off, my goal is calculate a total of time off but only if that time falls after today's date to get an accurate count of how much time I would have available.
Ex: sumif(b2:b366, IFA2:A366 '>='TODAY)
But I can't quite figure out how to make this work, any help would be greatly appreciated!
Apr 28 2022 09:48 AM
SolutionApr 28 2022 09:50 AM
Apr 28 2022 09:48 AM
Solution