Count of Date

[#1]

Hi ,

I need to count number of date between first day of year up today and like this for previous year.

I don't know what to do

please help me;

With Best Regards

Hamide

[#2]

Hi Hamide,

I hope this will help you out.

This year start date to today:

=num(Today())-num(YearStart(Today()))

Last year start date to today:

=num(Today())-num(YearStart(Today()))+365

[eromiyasimon]

to calculate today from this year start use below query

=Today()-YearStart(Today())

to calculate today from this previous year start use below query and the minus values goes on for every previous year

=Today()-YearStart(Today(),-1)

hope this helps

[Anil_Babu_Samineni]

Can you elaborate more

Do you mean Starting Date to Ending Date of the PY

[lakshmikandh]

YTQ, QTD, MTD and WTD

Count days between current selection in Master Calendar

Year to Date vs Year to date Last Year

[engishfaque]

Hi Hamide,

Here it is,

=Today() - YourDateField

OR

=YourEndDate - YourStartDate

Kind regards,

Ishfaque Ahmed

[ecolomer]

Days between today and first day of year:

=Today() - yearStart(today())

From Previous year to first day of year:

= yearStart(today()) - AddYears(Today(),-1)

[jonathandienst]

Counting off same number of days in previous year

=YearStart(Today(), -1) + (Today() - YearStart(Today()))

[#9]

Hi,

Thanks for  your answer, but my date is shamsi date

I want calculate the number of date between 1/1/1395 up today(12/8/1395) ;

My answer should be : 228

Regards

[Anil_Babu_Samineni]

Try Some thing Like this and then we can help you OR Please provide me sample Data which demonstrates the o/p

Count(Date(Interval(1/1/1395 - 12/8/1395),'DD/MM/YYYY'))