Yeah, I would love not use fake days, if possible.
I need to:
(1) to map from May 25 - June 24 to July - A
(2) to map from June 25 - July 24 to July - B (July - A and July - B need to be looked at separately)
(3) to map from July 25 - Aug 24 to Aug
(4) to map from Aug 25 - Sep 24 to Sep and so on
I asked about it last week without mentioning the July - A and July - B issue (seems like a fake month is needed unfortunately). Using your workaround, I was able to eliminate days from the 25 to the 30 but wasn't able to pull days from the pervious month to the current one (e.g. to pull July 25 - July 31) to August.
Re: Map Result from System Time (Days) to Customer Days (Fake Days)
Unfortunately, July - A and July - B are both for Actuals. The reason is May 25 - Jun 24 's salary (all calculation needs to be based on these days) need to be reported in July. And June 25 - July 24 's salary also need to be reported in July. We are showing double salary for July.
Ok, I see your issue and got it working but I did have to use a Fake Days list because the sum was having issues due to getting confused because of the different Time blocks (the mapping vs the real days).
I am sorry for a follow up question. Would it be possible to start with a "real date" module and then map the data to a "fake date" or "fake month" module?
Looking at your example, I would like to use PREVIOUS function, which fills a cell(s) with the contents of the cell above it, in module "Fake Time Days". This is why I want to start with a "real date" module to track changes on a particular day which applies onwards.
In the worst case, I can do an import from the real date module to the fake date module if the mapping doesn't work, but it would be great to map it.