COUNT TOTAL BASED ON TODAY()

Suresh Seetharaman

Hi,

I am trying to build a register for my staffs to calculate how many were present, sick, isolating etc., I tried to use the today function to calculate but it is not working. Any suggestions?

Thanks

Suresh

Suresh Seetharaman

Pic References

Bassam Khalil

Hi @Suresh Seetharaman 

Hope you are fine, if you like me to fix the formula directly on your sheet please share me as an admin on a sample copy of your sheets ( Source & Destination ) and i will Create the exact formula for you then you can copy it to your original sheet.

My Email for sharing : Bassam.k@mobilproject.it

Suresh Seetharaman

Hi Bassam,

I have given you access to a copy sheet. It would be really helpful if you could check it.

Thank you.

Suresh Seetharaman