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