¿Cómo encuentro el valor de auditoria diario?

Esta es mi formula:

=COUNTIFS({LAYOUT CHECK FOR DAL Range 5}, "DAL 1", {LAYOUT CHECK FOR DAL Range 6}, "Si", {LAYOUT CHECK FOR DAL Rango 2}, "14/08/20")

Cuenta si en columna 5 encuentra "DAL 1"

Cuenta si en columna 6 encuentra "Si"

Pero como hago para que busque siempre en fecha actual, es decir con alguna función today

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

My Spanish is pretty rusty (apologies), but looking at your formula it seems as if you may end up running into issues with how you are trying to count your dates. You are going to want to use the DATE function.

DATE(yyyy, mm, dd)

=COUNTIFS({LAYOUT CHECK FOR DAL Range 5}, "DAL 1", {LAYOUT CHECK FOR DAL Range 6}, "Si", {LAYOUT CHECK FOR DAL Rango 2}, @cell = DATE(2020, 08, 14))

All comments

Paul Newcome

DATE(yyyy, mm, dd)

=COUNTIFS({LAYOUT CHECK FOR DAL Range 5}, "DAL 1", {LAYOUT CHECK FOR DAL Range 6}, "Si", {LAYOUT CHECK FOR DAL Rango 2}, @cell = DATE(2020, 08, 14))

Ana Laura Rojas Nunez

THX Paul, my english is so bad, I will apply this advice

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.