Formula

Eric Laitenberger
✭✭✭✭✭
Hi,
I would like search into a column (Date) with count , date corresponding to February, If somebody can help me
Answers
-
Hi @Eric Laitenberger I can suggest a quick (and lazy) solution for you here, right next to your date column enter a month column which returns the number of the month for example, if date is 2/15/2023 - it would give 2 which is what you want. Then the simplest way is to just use this column to get your answer by =COUNTIFS(Column Name), "2"
Hope this helps!
Cheers,
Ipshita
Ipshita Mukherjee
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!