Skip to main content

New answers tagged

0 votes
Accepted

Return the percentage of the month that has elapsed up to today's date

Use DAY w/ EOMONTH NA Locale =DAY(TODAY())/DAY(EOMONTH(TODAY(),0)) International =DAY(TODAY())/DAY(EOMONTH(TODAY();0)) Format the cell's number format as percentage % EOMONTH function Returns a ...
Blindspots's user avatar
  • 5,156
0 votes

How to edit/append a cell value based on date range?

Formula in C2 Single array formula that will calculate all rows. =INDEX( IF(A2:A<>"", IF(WEEKNUM(TODAY())=WEEKNUM(A2:A), "", "x") & B2:B,))
Blindspots's user avatar
  • 5,156

Top 50 recent answers are included