Formula needed

[Slyon]

Hey all,

So I managed to solve one of my excel formula problems yesterday (thanks to this Forum ?), however I have now become stuck again..

(See previous post here How to class 'From' and 'To' dates that have the same date as 1 day, when counting amount of days from several dates.)

Following on from the above post, I now need to create another formula, which does the same thing but doesn't count any days from the dates given that are past a year ago from the current date.

If it helps, I'm trying to count how many days have been booked from the information entered on my spreadsheet, starting from the current date going back a year. This would need to basically eliminate any days that fall out of that time period.

Apologies if this doesn't make much sense! I'm open to new suggestions on how to get this info if needed. ?

 

[Fluff]

How about

=IF(F3<EDATE(TODAY(),-12),0,F3-MAX(E3,EDATE(TODAY(),-12))+1)+IF(H3<EDATE(TODAY(),-12),0,H3-MAX(G3,EDATE(TODAY(),-12))+1)+IF(J3<EDATE(TODAY(),-12),0,J3-MAX(I3,EDATE(TODAY(),-12))+1)

 

[Slyon]

How about

=IF(F3<EDATE(TODAY(),-12),0,F3-MAX(E3,EDATE(TODAY(),-12))+1)+IF(H3<EDATE(TODAY(),-12),0,H3-MAX(G3,EDATE(TODAY(),-12))+1)+IF(J3<EDATE(TODAY(),-12),0,J3-MAX(I3,EDATE(TODAY(),-12))+1)

That's worked, thanks!!

Say if I wanted to input the dates onto several different tabs (sheets) and then bring the total of those dates for each person say, using the format above onto the main first sheet to bring all totals onto one page.. is that possible?

 

[Fluff]

As that's a completely different question, it needs a new thread. Thanks

 

[Slyon]

As that's a completely different question, it needs a new thread. Thanks

No problem, thank you.