Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default hijri shamsi calendar

hi, i use date value function to change date to number and subtract them and
find number of days between them. how can i use hijri shamsi date format in
this function?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default hijri shamsi calendar

Perhaps looking at the source code he

http://www.vojoudi.com/vb/vb_date.htm

--
Regards,
Tom Ogilvy


"plainclothman" wrote in message
...
hi, i use date value function to change date to number and subtract them

and
find number of days between them. how can i use hijri shamsi date format

in
this function?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default hijri shamsi calendar

thanks a lot. i download the source.but how can I use this source in office
program. for example can it be as add-in in excell. i need it in access too.
can it create a built-in function that can be use in expressions.

"Tom Ogilvy" wrote:

Perhaps looking at the source code he

http://www.vojoudi.com/vb/vb_date.htm

--
Regards,
Tom Ogilvy


"plainclothman" wrote in message
...
hi, i use date value function to change date to number and subtract them

and
find number of days between them. how can i use hijri shamsi date format

in
this function?




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default hijri shamsi calendar

I didn't download the source, but as I understood it, it is in VB, so you
should be able to just put it in a general module and make it a function (if
it isn't already a function).

--
Regards,
Tom Ogilvy

"plainclothman" wrote in message
...
thanks a lot. i download the source.but how can I use this source in

office
program. for example can it be as add-in in excell. i need it in access

too.
can it create a built-in function that can be use in expressions.

"Tom Ogilvy" wrote:

Perhaps looking at the source code he

http://www.vojoudi.com/vb/vb_date.htm

--
Regards,
Tom Ogilvy


"plainclothman" wrote in

message
...
hi, i use date value function to change date to number and subtract

them
and
find number of days between them. how can i use hijri shamsi date

format
in
this function?






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert date from Gregorian Calendar to Hijri Calendar H.Alkhodary Excel Discussion (Misc queries) 1 February 21st 09 10:11 AM
hijri date Atlas Excel Discussion (Misc queries) 0 March 6th 08 05:30 AM
dates format using gregorian and hijri calendars sarif Excel Discussion (Misc queries) 0 December 12th 07 05:40 AM
comparing lunar (Hijri) day with a number Mossi Excel Worksheet Functions 2 March 20th 07 05:18 PM
How can I use Shamsi date in excel? Ghanbari Excel Discussion (Misc queries) 2 February 25th 06 11:11 AM


All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"