Excel In dire need of Excel help!

L

Lauren88

Joined
Dec 18, 2013
Messages
2
Reaction score
0
Hello!
I am completely caught on some data I'm working on and am hoping someone can help me. I am trying to figure out a way to use IF and TODAY together in order to get the difference (in "m" format) between today's date and a whole column of other dates. Is this even possible? For instance, if A1 is 1/2/13, A2 is 2/2/13, A3 is 3/2/13. Is there a way to subtract them all at the same time using IF and TODAY() and get the answers in a single month format (i.e. 11, 10, 9?
Thank you for your help.
 
You want to use the DateDif formula as follows (you can put this in column D or wherever, next to the dates you want to compare to the current date):
Code: 
=datedif(a1,today(),"m")

I am just doing this off the top of my head, let me know if it works for you!
 
Thanks, but I think I've got to use this: =IF(DAY(TODAY())>=DAY(A1),0,-1)+(YEAR(TODAY())-YEAR(A2)).
Thanks for your response!
 
So is that working for you then? I obviously didn't understand what you were going for.
 
Back
Top