Return a value when one date is less than another

Alex Hackford

I'm trying to project the amount of non-bill hours we plan to spend on a project between the non-bill approval date and the contract end date. I'm getting an invalid operation error when using this formula:

=IF([Column2]1 <= [Contract End Date]@row , [Approved Hours per week]@row , "")

Here's my column setup:

I've calculated the difference between created date and contract end date in the # of weeks until contract end" column. Then I did a vlookup for the "total approved hours" (from our governance approval sheet) and divided the total hours by the # of weeks" column value to get "Approved hours/week" column values.

In column 2-column 16, I am trying to populate the value in "Approved hours per week" if the date in row 1 of that column is less than the contract end date. I'm guessing I need some kind of date indicator w/in the IF statement? Any help would be greatly appreciated.

Brent Wilson

@Alex Hackford Is column 2 a Date column ?

If it is a date column, it should work

The amount of hours I have spent trying to figure stuff out, where I was trying to read a date from a date column or put a date in a text column..

Check that and let me know, and I can help further