# Numero semana **URL:** \ **Category:** Ask for Help\ **Created:** [August 12, 2024, 9:28pm UTC](https://community.glideapps.com/t/numero-semana/75610 "2024-08-12T21:28:17Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\ **Post date:** [August 12, 2024, 9:28pm UTC](https://community.glideapps.com/t/numero-semana/75610/1 "2024-08-12T21:28:17Z")
![NUMERO SEMANA](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/3/738558770c09dbffee6f94099ebed1e118c21194.jpeg) Alguien me puede ayudar a averiguar como hago para que las semanas sean de lunes a domingo, ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [August 13, 2024, 12:11am UTC](https://community.glideapps.com/t/numero-semana/75610/2 "2024-08-13T00:11:03Z")
Hola, Utiliza la formula _**WEEKDAY(A1, 2)**_ utilizando el plugin **Excel Formula** para ajustar los días de la semana a tu formato si lo deseas. El truco es convertir primero tu columna de Fecha en una tipo Texto y usar esa en la formula _WEEKDAY()_. Así luciría: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/6/a6b115a9f5c6aa57d43248ae12f05cf241a108cd.png) Para las semanas en específico, utiliza _**WEEKNUM(A1,2)**_ con el mismo principio. Saludos! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 13, 2024, 12:39am UTC](https://community.glideapps.com/t/numero-semana/75610/3 "2024-08-13T00:39:45Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f6784956ce729b7ef50183f60d55947d316e03a9.png) You can just use `WEEKDAY(D-1)`. ---
**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\ **Post date:** [August 13, 2024, 9:49am UTC](https://community.glideapps.com/t/numero-semana/75610/4 "2024-08-13T09:49:07Z")
El motivo de esta duda es saber que cuando calculo el numero de la semana me pilla siempre que el primer dia es el domingo, y yo quiero que las semanas las empieza de lunes a domingo, asi por ejemplo, esta semana es del 12 al 18 y es la 33, pero el domingo 18 ya me pone la 34, hay es donde tengo el problema…muchas gracias ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [August 13, 2024, 12:30pm UTC](https://community.glideapps.com/t/numero-semana/75610/5 "2024-08-13T12:30:00Z")
Hola! Utiliza la función _**WEEKNUM(A1,2)**_ como te indiqué arriba. Coloca por favor una imagen de tu pantalla para saber que tienes y el resultado que obtienes (y lo que esperar ver) si esto no funciona. ---
**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\ **Post date:** [August 13, 2024, 1:17pm UTC](https://community.glideapps.com/t/numero-semana/75610/6 "2024-08-13T13:17:15Z")
![SEMANA](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/3/a3dcece4222b2ebc276f97d2e6e894706a8bfb8b.jpeg) Observa donde tengo el error, es domingo y ya me cambia de semana ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [August 13, 2024, 1:21pm UTC](https://community.glideapps.com/t/numero-semana/75610/7 "2024-08-13T13:21:48Z")
Ok Puedes poner una columna donde vea la fecha exacta que usas para los cálculos? Así puedo simular mejor y replicar lo que tienes/quieres al llegar a mi casa. Saludos! ---
**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\ **Post date:** [August 13, 2024, 1:25pm UTC](https://community.glideapps.com/t/numero-semana/75610/8 "2024-08-13T13:25:46Z")
![FECHA ERROR](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d61526d63a0192fc23ba2c9bcae047f465e8e8e6.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 13, 2024, 2:41pm UTC](https://community.glideapps.com/t/numero-semana/75610/9 "2024-08-13T14:41:17Z")
You can use `WEEKNUM(D-1)` ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/f/efec411f975fae05a93b5866454a8011b28ad88a.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/d/9d0ef16d8528ca1e26fa75e5020952821bdc7881.png) ---
**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\ **Post date:** [August 13, 2024, 3:00pm UTC](https://community.glideapps.com/t/numero-semana/75610/10 "2024-08-13T15:00:02Z")
Muchas Gracias, pareque que si funcionó ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [August 13, 2024, 8:48pm UTC](https://community.glideapps.com/t/numero-semana/75610/11 "2024-08-13T20:48:43Z")
Nice tip! I didn’t remember that Math column has the WEEKDAY() and WEEKNUM() functions already incorporated!! ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/8/c8391c69237b6728829ff225062d8c8a4b6096a4.png) We need to update some documents 😉 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [August 20, 2024, 8:49pm UTC](https://community.glideapps.com/t/numero-semana/75610/12 "2024-08-20T20:49:08Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.