Excel formula to pull data between dates

Closed
JJR - 22 May 2010 à 00:10
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 22 May 2010 à 03:23
Hello,

I have a worksheet from a payroll program that is exported into Excel. In column A it prints the date and then names, the next date and then names, and so on... I need to reference the data between the dates into seperate worksheets.

Any one know a formula that will work.

Thanks,

JJR

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
22 May 2010 à 03:23
Not entirely sure what you are asking. If you just want to use value of a cell, you can use it like =A2