Hi Dave,
You could place a date in the Pay Period column in the Pay Calendars sheet and set its format to dd/yyyy and try using it in the vlookup.
Do you want to set the Pay Period format as "dd/yyyy"?
It would be better, if you can give us an example of what the input and the corresponding output would be.
Bookmarks