number of days between two dates

[Anonymous]

how to dynamically calculate in a variable , number of days between year start date and month of Month(today())-2..

Since we are in July the end date should be taken as April 30 2015..

[sunny_talwar]

Don't understand your questions Vinay. How many days from Year beginning to what date?

[Anonymous]

i need number of days between 01-01-2015 ( start date) and 05-31-2015 (end date)... this May 31 st date should be taken dynamically. like our current date is 07-15-2015, using this today's date it has to substaract 2 months and then take end date.. So now my number of days should be 151..let me know if you need more clarifincation

[MarcoWedel]

=DayNumberOfYear(MonthEnd(AddMonths(Today(),-3)))

[MarcoWedel · Accepted solution]

=DayNumberOfYear(MonthEnd(AddMonths(Today(),-2)))

[Anonymous]

Thank you Marco

[Anonymous]

Thank you Sunny for trying that

[MarcoWedel]

You're welcome.

regards

Marco

[Anonymous]

i find this community really helpful .. helping each other..