# calculate by date

#### bpflyr

##### Board Regular
I have posted this before, but I think I have an easier question format.
I have a logbook with hundreds of rows. I need Excel to calculate a specific column based on the previous 90 days total. This calculation will be done on a separate summary worksheet.

How can I get Excel to calculate for the previous 90 days and transfer that data to another worksheet?

Example

Date Flight Time
01-03-05 2.2
03-06-05 1.2
05-02-05 1.6

(and on a separte worksheet page)

Total Flight Time Previous 90 Days: ???

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Perhaps:

=SUMPRODUCT(--(Sheet1!A1:A14>=(TODAY()-90)),Sheet1!B1:B14)

replace Sheet1 with actual name of the sheet where the original data is found.
Adjust ranges to suit.

Thank you for your reply!! However, the formula is just returning a date of 1/0/1900. I need it to calculate a number based on 90 days prior worth of data.

P.S. I am sorry, I accidentally hit the Report button. Don
t know if this caused any grief or not.

It worked with my test.

Is your date column formatted as Date and is the result column formatted as number?
Book1
ABCD
121/3/20052.21.6
133/6/20051.2
1410/11/20051.6
Sheet1

SUMIF should suffice.

=SUMIF(A1:A3,"<"&TODAY()-90,B1:B3)

Change the criteria to suit your needs.

Replies
4
Views
165
Replies
6
Views
114
Replies
14
Views
330
Replies
1
Views
235
Replies
2
Views
69

1,196,514
Messages
6,015,654
Members
441,913
Latest member
Lhayden_69

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back