Number of days between 2 sets of dates (Word table)

**jayll** · 07-06-2011, 03:32 PM

Hi all,

I'm trying to find the simplest method to calculate the difference between two dates and express it as the number of days in a Word 2007 table cell.

For example: 'Issue Delta' (Cell A) was raised on the 22/09/2010 (cell B). Number of days the issue has been unresolved (cell C)

I'd like to find the number of days for cell C by comparing TODAY and 22/09/2010 (or another set date).

Unfortunately formulas in Word are a bit limited - and at that point we run into my knowledge barrier!

Any help gratefully received.

**snb** · 07-11-2011, 09:33 AM

Just a little bit of VBA:

sub snb()
  activedocument.tables(1).cell(1,3).range.text=datediff("d",cdate("22/09/2010"),date)
end sub

or reading from the table

sub snb()
  with activedocument.tables(1)
     .cell(1,3).range.text=datediff("d",cdate(left(.cell(1,2).range.text,len(.cell(1,2).range.text)-2),date)
  end with
end sub

Thread: Number of days between 2 sets of dates (Word table)

Thread Tools

Rate This Thread

Display

Number of days between 2 sets of dates (Word table)

Re: Number of days between 2 sets of dates (Word table)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions