mind

I'm trying to could the number of days between a set of days. Example: 1/1/19 - 12/31/19. I need to could the days between 6/1 & 11/31 and never mind the year. If the dates are 1/1/19 to 12/31/20 then I need it to count them.

I have a 4 digit padlock like this one that I have forgotten the number to. I can buy a new lock for ~$15 but I'd rather try & unlock the one I have. I'd like to create an excel sheet that contains all the different possible combinations (10,000 of them). That way, I can keep track of the...

I have a formula =INDEX(Sheet_1_crosstab.csv!$D:$D,MATCH(1,(A2=Sheet_1_crosstab.csv!$B:$B)*(B2=Sheet_1_crosstab.csv!$C:$C),0)) It's great for giving me the first result from Column D in my Sheet_1)crosstab.csv that matches my 2 different criteria. What I can't figure out is how to get the 2nd...

Hello,<o:p></o:p> I am trying to replicate the formula below in excel, but can't quite get it right. The aim is to use the formula to help drive data that I can graph into an s-shaped sales curve. The formula I have is:<o:p></o:p>...

I know this is probably simple, but I'm trying to add two cells and then divide by another cell. So far I have this =a2+a3/a4 and it doesn't work. Sorry. never mind =(a2+a3)/a4 figured it out.

I'm am a stuck newby in ACCESS. I haven't done anything in access before but know programming, VBA, and RDMS (some better, some passing). I have a Access database structure that I have designed and have had checked. My data is in spread sheet (2000 records) that I have reused some columns for...