First of all hello. I am new to this forum and appreciate any assistance. I have attached the spreadsheet. Based upon the current date, I need to be able to count the number of days absent in the past 90 days.
First of all hello. I am new to this forum and appreciate any assistance. I have attached the spreadsheet. Based upon the current date, I need to be able to count the number of days absent in the past 90 days.
Hello pumpkinalden, and welcome to the forum.
Try this in cell GC11 and drag down:
=COUNTIFS($B$10:$GB$10,">="&TODAY()-90,$B11:$GB11,"P")
assumes you will insert new column to add new date.
Thank you so much for the help. If I wanted to replace the &Today() portion of the formula so that it looks at a particular cell would I just do this ($B$7-90)?
No, because you would count everything greater than 90 days prior to the date in B7
You would have to "cap" the range of dates, like:
=COUNTIFS($B$10:$GB$10,">="&$B$7-90,$B$10:$GB$10,"<="&$B$7,$B11:$GB11,"P")
The first formula, using TODAY(), didn't need that cap because your sample implied that dates were added as they occur, so there would be no dates greater than TODAY().
Thank you very much I really appreciate this. It worked perfectly.
You're quite welcome.
Please remember to mark your thread as Solved. Thanks.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks