The first one
=(MOD(F13,10^6)-MOD(F13,10^4))/10000

divides the date by 10^6 or 1 million and gets the modulus (remainder)= 39541
or if converted to a date the same as in F13
divides the date by 10^4 or 1 thousand and gets the modulus (remainder) = 9541
it subtracts these 2 values and get 30000 and divides that by 10000 and gets
the answer of 3

I think from that you should be able to work our what the second one is
doing while I work out why!!

Mike

"Mifty" wrote:

Hi everyone,

Is there any chance that some kind soul could tell me what these 2 formulae
are doing please?

F13 is a date

=(MOD(F13,10^6)-MOD(F13,10^4))/10000

=(MOD(F13,10^6)-MOD(F13,10^4))/10000+MOD(F13,10^4)*100

Thank you very much





--
Mifty