There is a way to determine the day of the week with formulas. Let's say A12 is the date. Then just do a "mod(a12,7)". This will return a value from 0 to 6. With 0 being Sunday, and 6 being Saturday.
You could mod your current date. Then have a cell that subtracts that value...
Thank you,
Hadn't thought of that. I know it will work. But I'm still going to try to figure the syntax to get it all in one. It's one of those problems that I have to see solved. Being an engineer, I'm sure you understand.
Thanks again,
Gary
Back in the day, I used to be a Q-Pro wiz. I knew how to do it all. Then windows replaced dos, and Excel replaced Quattro Pro. Now I need to perform one of those old tricks, but I can't get the syntax just right, and maybe someone can help me.
I want to nest an HLOOKUP inside a VLOOKUP. I...
That is a great function. I never knew it existed. I've been using Excel for about 6 years, and never had any training. So when I couldn't find a function to do what I wanted, I had to make up my own.
Thanks for pointing this out. But.... My equation could be used anywhere. Fortran...
This may help someone. I recently developed a spreadsheet that calculated some pressure settings for a machine I was in charge of. The pressure gage read in 50 psi incriments, but my spreadsheet output was rounded to the nearest 1 psi. Excel will round to decimal places, not numbers...
