Forum Discussion
Calculating the number of days within a 12-month period
Hi there! I have created a spreadsheet that displays the trips that my bosses have gone on, including the date range and the location followed by a third column of the actual # of days in the dat...
Hi Judie,
If you split first column on two with start/end day like this
the formula could be
=SUMIF($A$2:A2,">="&EOMONTH($A2,-12),$D$2:D2)
and it depends on how do you calculate 12th months, from first day of the month, from last day of the trip or so.
In any case both could be adjusted (if both dates in one column and 12 months calculations), above is just an idea.
Attached.
Thanks Sergei so much for the help! I'm going to try it right now and see if it works with my data! Will let you know how it turns out!