Skip to Content
Author's profile photo Former Member

To Display Data for 4 Previous Days from Selected Date & Previous Month Data of Selected Date in Dashboards

Hello All,

I just wanna share a strange requirement which i faced in developing a dashboard.

The requirement is stated below,


Display Dates for,

•Selected Date = 21 Nov 13

Previous 4 days = 20 Nov 13  to  17 Nov 13

Previous month Selected date = 21 Oct 13

I have implemented this requirement by using multiple Vlookup’s.

you can find the implementation process from the source file attached.


Open the attached file with dashboards(.xlf extension )

Best Regards,

Samatha B.

Assigned tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Bulent Ozgul
      Bulent Ozgul

      can't see any attachment

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Now you can find the attachment.