Differences

This shows you the differences between two versions of the page.

--- en:user_guide:excelfunction [2022/04/09 18:03]
tiger [Cell references in Excel functions]
+++ en:user_guide:excelfunction [2022/10/25 14:10] (current)
tiger [Dates]
@@ Line 1: / Line 1: @@
 {{indexmenu_n>9}}
-====== Excel functions in Djeeni process step parameters ======
+====== Excel functions in Djeeni processes ======
 Djeeni is created for people who have built up experience and proficiency in MS Excel by using it regularly for different data processing tasks. We do want you to be able to keep and utilize your proficiency and therefore built Djeeni to seamlessly work together with MS Excel and its powerful built-in functions. In the sections below we explain through practical examples how and for what purpose you can embed Excel functions at different Djeeni process steps.
@@ Line 70: / Line 70: @@
 Based on these issues we suggest that you use dates in Djeeni processes following these guidelines:
   - Whenever possible store every date in three separate cells: year; month; day
-  - Combine the three values (let's suppose year is A1; month is B1; day is C1 on worksheet wsSheet) into a date by [+DATEVALUE("[=wsSheet!A1]-[=wsSheet!B1]-[=wsSheet!C1]")] (using the standard year-month-date order). NB: under certain circumstances [+DATE(year, month,day)] creates a year-day-month date (e.g. makes 5th March from 3rd May) in Djeeni so avoid using it.
+  - Combine the three values (let's suppose year is A1; month is B1; day is C1 on worksheet wsSheet) into a date by [+DATE([=wsSheet!A1],[=wsSheet!B1],[=wsSheet!C1])] (using the standard year-month-date order). Djeeni will use the underlying number value of the date ensuring consistency on all platforms and locales.
+  - Pre-format your target cells to short date or long date to display correct date strings (instead of number values).
 ===== Cell references in Excel functions =====

User Tools

Site Tools

Differences

Page Tools