Select the first cell of the column you want to store the result in (in our example, cell H2).Type ‘=’ and select the first cell of the column containing the dates you want to add days to (cell A2).Next, type ‘+’ followed by the number of days you want to add. ...Press the Return Key on your keyboard. ... More items... ...

First, identify the starting and an ending time. The goal is to subtract the starting time from the ending time under the correct conditions.If the times are not already in 24-hour time, convert them to 24-hour time. ...Determine whether the number of minutes is larger in the starting time or the ending time. ... ...

Method 1 Method 1 of 3: Counting Days Between Periods Download ArticleStart counting on the first day of your period. To get an accurate depiction of your menstrual cycle, start counting on the first day of your period.Count up to the day before you start your next period. Your count resets on day 1 of your menstrual cycle.Monitor your cycle for at least 3 months. ...Calculate your average cycle length. ... More items... ...

You can use the INTCK function to calculate the difference between two dates in SAS. This function requires you to define the interval, the start date, and the end date. Depending on the interval, it returns you the difference in days, weeks, months, etc. INTCK(interval, start date, end date <, method>) ...