I'm working on a spreadsheet that reflects a hire date and I need to add 6 months to that date. Further, I need to reflect in another column the first date of the next quarter.
For example
Hire date 2/15/12
+ 6 months 8/15/14 (Note I need the year to be current)
1st Qtr following 6 month date 10/1/14 (this is based on QTR dates 1/1, 4/1, 7/1, 10/1)
Any suggestions would be great
6 months from date:
Formula:
Please Login or Register to view this content.
Start of next quarter after 6 months from date:
Formula:Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
This is great! Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks