Share via

In 2017 the Islamic month of fasting, Ramadan, began on Friday, 26 May. What fraction of the year was this? (to 1 decimal place)

Anonymous
2022-12-13T05:11:18+00:00

Hi

I want to know the year fraction of Ramadan 2017, which started on 26 May & ended may be 24 June in 2017. pls explain, how can I calculate the year fraction.

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2022-12-15T11:01:05+00:00

    It is easier to understand how to calculate that if we do it with simple numbers first.

    The 1st step is to calculate the size, for Sector we have 2,3,4 means 3 numbers which can be calculated by
    B5: =B3-B2+1
    Same for Area

    The fraction of Sector / Area is
    C6: =B5/C5

    All you have to do to answer your question is to write the dates into the cells.

    Andreas.

    5 people found this answer helpful.
    0 comments