Report Calculation - Number of Weeks betwen 2 Dates?

T

Todd D. Levy

IF I have fields in a report that are a Start Date and an End Date
for a period of time, can I have a calculation of the number of week
that this time period encompasses?
 
R

Rick Brandt

Todd D. Levy said:
IF I have fields in a report that are a Start Date and an End Date
for a period of time, can I have a calculation of the number of week
that this time period encompasses?
Click to expand...

Check help file for DateDiff() function.

NOTE: DateDiff counts "boundaries crossed" so a DateDiff of weeks between Saturday
night and Sunday morning will be one. This often means that you have to use a
smaller interval for the DateDiff and then divide to get the value you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automate update on weekly reports spreadsheet 0
Display weeks from a Milestone 0
Show week number in Project Report 0
Weekly Report 2
MS Project. Real progress of the project, % complete 1
Receiving unexpected Duration 0
Enable Iterative Calculations 0
Calculate records with dates from past week and month 4

Top