I worded previous wrong. I know how to add 45 days. DUH. My question is:
If one date is 9/1/07 and the second date is 10/16/07. In the third cell, I want it to say YES or NO if those dates are within 45 days of each other.
IF they are past 45 days...I want the formula to say NO.
2007-11-28 05:58:33 · 4 answers · asked by MUGS 1 in Computers & Internet ➔ Software
SLICK YOU ROCK! YOU'RE ANSWER WORKED!!!!
2007-11-28 06:47:08 · update #1
Dates are stored as numbers internally and can be compared as such.
=if(a1-b1<46,"yes","no")
✩
2007-11-28 06:10:41 · answer #1 · answered by Barkley Hound 7 · 1⤊ 0⤋
The only way I can think of is to, for example...
put 9/1/2007 in cell A1
put 10/16/2007 in cell B1
format column A and B as dates
in cell C1, enter formula =B1-A1
change format of column C to number
in cell D1, put formula =C1=45.
So, in one row, you'll have date 1, date 2, number days, then TRUE/FALSE
kind of complicated, but if you have alot of dates to go through then it's easy. Just drag down formulas. Hope this helps.
2007-11-28 14:10:04 · answer #2 · answered by Alison 2 · 0⤊ 1⤋
of course adjust your cells accordingly.
=IF(B1-A1<=45,"Yes","NO")
===============================
Also keep in mind that Excel looks at date as numbers (thats a differnt topic) and that you need to see if you want to include the start date and the end date in your fomula and modify accordingly as nov 1 - dec 15 if you include the 1st and the 15th wont trip your if statement till the 17th as being over 45 days.
2007-11-28 14:06:16 · answer #3 · answered by Slick 5 · 1⤊ 0⤋
wow i know alot about if formulas, but that doesn't make sense. It will be hard to do with an actual date. If it was just and individual number it would work. Good luck
2007-11-28 14:04:05 · answer #4 · answered by loving life!!!!! 6 · 0⤊ 1⤋