calculate number of weeks between today and a start date

[Jclarka]

I have excel from office professional 2016 .
I am trying to calculate the number of weeks between today's date and a task start date (expressed as an integer). Any help would be appreciated.

[AliGW]

How about this?

=($A$5-C11)/7

[BMV]

Please define "number of weeks"

Please Login or Register  to view this content.

[Pete_UK]

You might want to ROUND the result, as your last entry (which is 13 days ago) will show 1, like this in D11:

=ROUND((($A$5-C11)/7),0)

and if your date is in the future you will get a negative result, so you might want to do this to prevent that:

=MAX(ROUND((($A$5-C11)/7),0),0)

Hope this helps.

Pete

[alansidman]

An alternative means is with Power Query which seems a bit more convoluted but is here only as a learning option.

Please Login or Register  to view this content.

Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

- Follow this link to learn how to install Power Query in Excel 2010 / 2013.

- Follow this link for an introduction to Power Query functionality.

- Follow this link for a video which demonstrates how to use Power Query code provided.

[Jclarka]

thanks Ali. I was sure that wasn't before!

[Jclarka]

thanks BMV. Interestingly the no. days between today and a start date of 01Oct2018 was one day more using Ali's solution above. The others were the same.

[Jclarka]

thanks Alan,

I still a novice at Excel. Also I couldn't open the links. I am sure I will use Power Query as I get to grips with Excel. Thank you.

[Jclarka]

thanks Pete. That works well.

[Pete_UK]

Glad to help, and thanks for the rep.

Pete