Something like this:
=IF(AND(E2>$A$1,E2<$B$1),formula+85,IF(AND(F2>$A$1,F2<$B$1),formula+85,""))
Where A1 and B1 are your dates
Something like this:
=IF(AND(E2>$A$1,E2<$B$1),formula+85,IF(AND(F2>$A$1,F2<$B$1),formula+85,""))
Where A1 and B1 are your dates
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks