=0

The result for the expression, =0 must be a blank value

 

=365*24

One year after the reference date in the UTC (+0) time zone

Depends on the current time zone of the server. For example:

In the EST timezone (-05:00), the time point will be 1970-12-31 19:00 with the result 1970-12-31.

In the CET time zone (+01:00), the time point will be 1971-01-01 01:00 with the result 1971-01-01.

='Start Date' + 'Man Hours' / 40 * 168

Calculates an approximate end date for a project where one person works full time without vacation. Start Date: 2004-08-01. Man Hours: 80

2004-08-15