Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Converting Dates between Gregorian to Afghani Calendar

Hello,

I need your help in creating a calendar that converts the dates from Gregorian Calendar to Afghani Calendar. Afghani Calendar is solar calendar which mean it has 365 days. It is not Lunar Calendar. So year 2006 = 1385 afghani calendar. So this mean that G= A + 621 and A= G- 621.

The problem I have is converting the months and days. The new year for Afghani Calendar is march 20 or 21 (depends on which day is the first day of spring). So the new year 1/1/2006 is 3/20/1385.

I would like to create a excel file that does this conversion and as well show the month and days graphically.


Post your answer or comment

comments powered by Disqus
i need Convert date from Gregorian Calendar to Hijri Calendar in my worksheet

Hi all,

I need to link excel 2007 dates and subject to Outlook Calendar 2007.

I have spent the last two days reading various posts in numerous forums about this topic but I am lost.

I need code (I think) to add the following ranges (Subject/Date) to the Calendar.
Ranges are as follows:
Subject/Date
New a-z
G2:G500 and H2:H500

Data Ireland Entry
V2:V500 and W2:W500

Barbour entry
P2:P500 and Q2:Q500

Other entry
P2:P500 and Q2:Q500

Thank you for taking the time to read this, I appreciate your help.

I have a function to convert date of birth to # of months old as of today,
but need the function to convert date of birth to # of months old in 30 days,
in 60 days, in 90 days, etd.

regarding dates using Gregorian and hijri calendar b1/dd/mm/yy is not respond
also enter in a cell (excel) add/mm/yy also not respond please help me to

Anyone know an algorithm for conversion from Gregorian calendar dates to Islamic calendar (Hajji ) dates?

Rgds

Ian

Hi, I am trying to find a quick way to convert dates in excel to text. I am having problems with the date number that excel uses and would prefer the dates as text. This needs to be done as the dates are brought in from an access database but for ease of use I need the dates as text in excel. can anyone help please

Can anyone please help me? is there a function in excel to convert Date of
Birth data into Age? or a forumula to help?

Many thanks
Wendy

I have a spreadsheet... column A lists my current projects... columns B-D
list out key dates for my projects. I want to put these dates from the Excel
sheet in a calendar. Can I export the data to a calendar or add the data to
a calendar-type chart?

is there a way to convert an excel spreadsheet to a calendar format?

I want to create a booking form in excel which transfers the names and dates
to a calendar, like appointments in outlook. Is there a way to do this?

Hello,
Can somebody help me to convert the following date? I want to add the current year "2011" and change the format to 1/1/2011 if possible. If not, I'll settle for Jan 01, 2011.

A1: Jan 01
A2: Jan 02
A3: Jan 03
etc.

Thanking you in advance for any and all help you can provide.

Dear,

I have an Excel sheet in with 2 columns: Column A holds a date in the European format "dd/mm/yyyy" and column B holds a number in the European format "#.###.##0,00".

This data is used to complete a listbox in a userform so the user can choose with which date and number to continue some calculations.

Now, when completing the as follows, the values are casted to strings with the wrong value:
Code:
 UCList.AddItem
        UCList.List(UCList.ListCount - 1, 0) = MyCell.Value
        UCList.List(UCList.ListCount - 1, 1) = MyCell.Offset(0, 1).Value
If I check in the "Wachtes" window, mycell.value = 65,864356134631 (sixty five and then some decimals) and mycell.offset(0,1).value = 03/02/2008 (February 3rd). After assigning the values to the list, these value become 65864356134631 and "02/03/2008". If I later on call this date form the UCList, the date becomes the 2nd of March and the number a huge number (=+/- 6*10^14 ).

The problem probably is most likely caused by the cast to string when completing the list and the cast to double or date when reading the list values.

Is there a way I can tell VBA that I live in Europe and that we use a different date system? Just like you can set it in Excel in Tools>Options>Internation>Number Handling?

I can solve this by using
Code:
 UCList.AddItem
        UCList.List(UCList.ListCount - 1, 1) = format(MyCell.Value,""#,###,##0.00")
        UCList.List(UCList.ListCount - 1, 1) = format(MyCell.Offset(0, 1).Value,"dd/mm/yyyy")
but this is just one of those patches which does not really solve the root problem.

In addition, this continuously switching from US to European date and number format, makes my code quite confusing.

Any help on this will be highly appreciated.

Hello,

Do any have a finction which will enable to convert date from Gregorian
to Hijri and Vise Versa?

Thanks

I need help converting Julian Date to regular calendar date.
I have from 5000 – 10000 Julian Dates in one column. Ex.
Col A need converted to
4001 = 1 Jan 04
5001 = 1 Jan 05
5030 = 30 Jan 05

Any help would be much appreciated.
Thanks
Ron

--
Ron

I have two columns (B & C) of dates (mm/dd/yy). The first colmn is the result
of converting a Julian Date (col A) to the calendar date, so there is a
formula hidden in cell B under the date. I am using the formula
=DATEDIF(B27,C27,"d") to determine the number of days between the two dates.
This does not work with the two colums in my worksheet that has the hidden
formula. The answer I get is #NAME? (this is the formula behind cell B
=DATE(INT(C3/1000),1,MOD(C3,1000)) ).
If I put a date in col b (not a result of a formula from Col A) and use this
formula(=DATEDIF(B27,C27,"d") ) it works. Example 2
I am guessing the hidden formula is messing up my work?
I am using Excel 2000

EX. 1
Cols
A b c D
5001 01/01/05 01/10/05 #NAME?

Ex 2
A
Blank 01/01/05 01/10/05 9
--
Ron

I have two columns (B & C) of dates (mm/dd/yy). The first colmn is the result
of converting a Julian Date (col A) to the calendar date, so there is a
formula hidden in cell B under the date. I am using the formula
=DATEDIF(B27,C27,"d") to determine the number of days between the two dates.
This does not work with the two colums in my worksheet that has the hidden
formula. The answer I get is #NAME? (this is the formula behind cell B
=DATE(INT(C3/1000),1,MOD(C3,1000)) ).
If I put a date in col b (not a result of a formula from Col A) and use this
formula(=DATEDIF(B27,C27,"d") ) it works. Example 2
I am guessing the hidden formula is messing up my work?
I am using Excel 2000

EX. 1
Cols
A b c D
5001 01/01/05 01/10/05 #NAME?

Ex 2
A
Blank 01/01/05 01/10/05 9
--
Ron

how do I convert a julian gregorian date code into a regular date. I have a
julian gregorian (1582) date code that I want to convert into a regular
month/day/year code. How do I do this? Is there a formula for this? Here
is a sample date code: 2453523.

I'm looking for a function that will let me convert a long list of Excel
dates into their Hijri equivalents. I understand that the latest
versions of Excel will do this, but:

# I want this to work with earlier versions of Excel

# I want the output to be in Roman, not Arabic, script

The format that would be ideal for me would be similar to that found in
the Fourmilab calendar converter:

http://www.fourmilab.ch/documents/calendar/

So that a date shown as

Thursday, 15 December 2005

in Excel's "dddd, dd mmmm yyyy" format would be shown as

yawm al-khamis, 14 Dhu'l-Qada 1426

in the Hijri conversion. Obviously I can't type in each date and write
down each converted version!

--
Del Cotter
NB Personal replies to this post will
send email to del@branta.demon.co.uk
Please send your email to del2 instead

info.xls

Hi folks,
I need a little help how to have reminder date from Excel xls into Outlook calendar.
It might be simple but our office IT guys couldn’t figure out so I need some help... I created a sample xls file with proper columns – attached. I am not a programmer so I am trying to figure out how to have automatic reminders 3 days before the “Start Date” which will be different for each item and there will be thousands of items on this list.

I appreciate your help.
Thanks

also my file is here http://www.allreversephonelookup.com/excel/info.xls

Hi there,

I'm just new at learning Excel and Access and i need some information on how to convert date to number in Excel and also how to set and apply a filter that shows only certain records (eg.all dates before 31/1/04) which is in Access.
That would be great if anyone can help :

Hi,
Is there a way to convert date to text of format (number stored as text) either directly using excel formulas or VB macros.
We've a requirement to pass today's date as a string in the format of "number stored as text".

For this, i've in cell A1 a formula today() which gives today's date 10/15/2007 and I'm looking an output of '20071015 in cell A2 and this should be treated as text with a symbol " ' " before 20071015.
Appreciate any help.

In sheet1 i have two dates

Eg. 11/6/2007 - 22/6/2007

In sheet2 is the calendar and I want the period in between these two dates in sheet2 to be highlighted in red.

How do i do it?

I am trying to convert a date to a number but there is a twist here. If I convert 05/19/2006 to a number it comes out 38856. I can format the date to look how I want which is 20060519, but what I want is for that date to become a number that is the same 20060519, but as a number. Any ideas?

How can I convert dates to Week of the year

Example: 01/11/04 - Week 45
20/12/04 - Week 52

How can I do that?


No luck finding an answer? You could always try Google.