convert date difference to week number

**paascal** · 05-24-2012, 01:21 PM

hellooo,

i would like to know the number of weeks if i subtract to cells containing dates, is this possible?

thanks

**dilipandey** · 05-24-2012, 01:27 PM

Hi Paascal,

If you have dates in A1 and B1, try below formulas:-

=ABS(WEEKNUM(A1)-WEEKNUM(B1))

or,

=ROUND(ABS(A1-B1)/7,0)

Regards,
DILIPandey

<click on below 'star' if this helps>

convert date difference to week number

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

convert date difference to week number

Re: convert date difference to week number

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions