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
thanks i will try that i just am not sure if i keep the $ or not
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks