MS Excel / VBA help thread

You are reading a single comment by @Chalfie and its replies. Click here to read the full conversation.

•

aggi in reply to @Chalfie

Yes, I've got the date table in to link them. But the trouble is when I have a sale on 1/07/18 but no FX rate on 1/07/18 (it was a Sunday) then it returns a blank as there is no corresponding record.

•

Chalfie in reply to @aggi

I’m trying to remember how we got around this with specimen dates in our reporting for Covid and can’t remember right now

I think it was by adding days or something but I think that was to set to a reporting week.

About

Avatar for Chalfie @Chalfie started