redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
Hello all
as per excel sheet example below, I would like a formula that will check down the dates in column A and count the current months occurrences.
So the formula in cell C1 shows current month is Apr21 and I'd like a formula then placed into cell D1 to give the result shown in D1
Thanks in advance
as per excel sheet example below, I would like a formula that will check down the dates in column A and count the current months occurrences.
Running (version 2).xlsb.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 11-Jan-21 | Apr 21 | 2 | |||
2 | 15-Jan-21 | Mar 21 | 4 | |||
3 | 17-Jan-21 | Feb 21 | 2 | |||
4 | 18-Feb-21 | Jan 21 | 3 | |||
5 | 19-Feb-21 | |||||
6 | 02-Mar-21 | |||||
7 | 04-Mar-21 | |||||
8 | 06-Mar-21 | |||||
9 | 11-Mar-21 | |||||
10 | 01-Apr-21 | |||||
11 | 04-Apr-21 | |||||
12 | ||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C1 | C1 | =TEXT(TODAY(),"Mmm yy") |
C2 | C2 | =TEXT(TODAY()-30,"Mmm yy") |
C3 | C3 | =TEXT(TODAY()-65,"Mmm yy") |
C4 | C4 | =TEXT(TODAY()-90,"Mmm yy") |
So the formula in cell C1 shows current month is Apr21 and I'd like a formula then placed into cell D1 to give the result shown in D1
Thanks in advance