Convert date to time format
I want to calculate the # of days in a month without using the PERIOD function. No time scale for this module.
E.g. 10/15/2015
0
Best Answer
-
You would use the DAY function - if I'm understanding your need correctly…|
0
Answers
-
@LeiCuntapay
Directly from date without using period function you cannot fetch Month, you can use workaround mentioned - Find the month number using Month formula from current date
Create 2 lists number 1- 12 and month list Jan 24 - Dec 24, create mapping of these lists.
From month number by using number to text, Text to list conversion formulas, FINDITEM() fetch the Month(by means of mapping module using lookup) then by day function you can calculate number of days.
Any specific reason you want to avoid period function.0