I have a table from M12:W24.
In M12:M24 are dates
In Cell W14 I would like it to look at todays date, and compare this against M15 (So it looks if todays date is before the start of next month)
If it is, I want it to count the number of "YES" in A1:a100
If it is beyond that date, I don't want the value to alter from last time its added up. (Is it possible to reference the cell below, if blank then carry out the count, if it contains a value, then I don't want it to recalculate.
To be honest I don't think this is going to be possible unless I change the "YES" for a date.... but that's going to involve a lot of going back on myself exchanging all the YESES for the particular dates....
In M12:M24 are dates
In Cell W14 I would like it to look at todays date, and compare this against M15 (So it looks if todays date is before the start of next month)
If it is, I want it to count the number of "YES" in A1:a100
If it is beyond that date, I don't want the value to alter from last time its added up. (Is it possible to reference the cell below, if blank then carry out the count, if it contains a value, then I don't want it to recalculate.
To be honest I don't think this is going to be possible unless I change the "YES" for a date.... but that's going to involve a lot of going back on myself exchanging all the YESES for the particular dates....