HOW TO CONVERT DATE INTO NUMBERS

Advertisement
October 11

HI,
what the syntax for converting date into No. Ex from the first date of the month till current date how many days are there, this No of days needs to be divided by the net sale of the month.
i have searched in formulas fields but i am not able to find such option...
please help.
Thanking you,
UMAR NAYAB.

Advertisement

Replay

Hi,
Stratos and Sastry
the formula given by you shows the variation for the current month of suppose 30 days
but if the month is of 31 days or 28 days (feb) how will the system will able to generate the report accordingly.
i want to make a report in which it should show the net sales by the current month and current date.
so the system should automated by the number of days in a month.
thanking you..
UMAR NAYAB.

View 6 Replies

Tags:

  1. B8000_A422_000_085_140402_WW_WIFI
  2. my ipod wont turn on
  3. java deconfig for old jav r12
  4. LFJ9
  5. DAQmx_Val_ChanPerLine
  6. 9J18
  7. notp8z
  8. officialwv4
  9. helloogq
  10. protectionb1d
Copyrights 2019 Fcffair BigData Resource, All rights reserved