A formula of =DateDif(Q3,Today(),"D") returns the number of days between Q3 and todays date. I need to return the numbers of days between the 2 dates on a weekly basis not a daily basis.
Jim O
A formula of =DateDif(Q3,Today(),"D") returns the number of days between Q3 and todays date. I need to return the numbers of days between the 2 dates on a weekly basis not a daily basis.
Jim O
Last edited by JO505; 08-12-2015 at 03:01 PM.
what do you mean by days(?) on a weekly basis? Do you want the # of weeks or the number of days?
Last edited by protonLeah; 08-12-2015 at 02:05 PM.
Ben Van Johnson
Instead of counting every day between the 2 dates I want to count on a weekly (7 day) basis. A unit of 1 for every week between the dates instead of 1 unit for every day.
Hope this helps.
Jim O
Here is a sample of my data.
Jim O
JO505, Good afternoon.
Using your example as reference, try to use:
E2 --> =TRUNC(D2/7,0)
Is that what you're looking for?
I hope it helps.
...If my answer helped you, Please, click on. * Add Reputation (at left)
Best regards.
Marc?lio Lob?o
Marcilio,
Thanks for the response. I think that is a workable solution. I have nested both formulas as below.
Jim O=TRUNC(DATEDIF(C2,TODAY(),"D")/7,0)
E2:
=int((today()-c2)/7)
protonLeah,
I like it.
Thanks.
Jim O
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks