First date within 2 tables

shophoney

Board Regular
Joined
Jun 16, 2014
Messages
219
Hi I have 2 payroll tables MAIN and MGMT. They both have dates and are linked to a common calendar table.

I would like to know the first date you were paid from both tables.

You could only show up on the MAIN or MGMT or both.

Is this possible?

thanks
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,102,462
Messages
5,487,024
Members
407,576
Latest member
aapnarritesh

This Week's Hot Topics

Top