计算天数 [英] Calculate Aging of Days

问题描述

你好

我会尽力解释.我有两列(日期发布和目标响应日期). 日期发布"列的含义与开始日期相同. 目标响应日期"列意味着将日期设置为到期日.

I will try to explain it as best as I can. I have two columns (Date Issue & Target Response Date). Date Issue column meaning the same as start date. Target Response Date column meaning the date will be set to be due.

没有日期的情况下，用于计算日期发布"和目标响应日期"之间的期限的公式是什么.

What is the formula to calculate the aging between Date Issue and Target Response Date without weekends.

如何设置它在5个工作日内通过电子邮件通知我?

How do I set it to notify me by email when it is due within 5 business day?

请帮助....

推荐答案

>计算日期发布和目标响应日期之间(不包括周末)的期限的公式是什么

> What is the formula to calculate the aging between Date Issue and Target Response Date without weekends

网络上的许多示例.来一个

Lots of examples on the web. Here's one.

https://sharepoint.stackexchange.com/questions/88149/formula-to-show-differens-between-dates-without-weekends-and-holidays

https://sharepoint.stackexchange.com/questions/88149/formula-to-show-differens-between-dates-without-weekends-and-holidays

>如何设置它以在5个工作日内到期通过电子邮件通知我?

> How do I set it to notify me by email when it is due within 5 business day?

创建提醒工作流程.

这篇关于计算天数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！